Q
Problem solve Get help with specific problems with your technologies, process and projects.

Errors exporting an Oracle database

I am having a problem exporting an Oracle database. The error I got is, "exporting operators, exporting referential integrity constraints, exporting triggers."

 
EXP-00056: ORACLE error 6550 encountered

ORA-06550: line 1, column 26:

PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared

ORA-06550: line 1, column 14:
 
PL/SQL: Statement ignored
 
EXP-00056: ORACLE error 6550 encountered
 
ORA-06550: line 1, column 26:
 
PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
 
ORA-06550: line 1, column 14:
 
PL/SQL: Statement ignored
 
EXP-00000: Export terminated unsuccessfully
Please tell me how can I solve this.

First, verify that this package exists with the following query:

SELECT status,object_id,object_type,owner,object_name
FROM dba_objects
WHERE object_name = 'DBMS_XDBUTIL_INT';

If the status is INVALID, then recompile the package. If the package does not exist, then you will have to install it as follows:

SQL> connect sys/
 
   AS SYSDBA    
SQL> @?/rdbms/admin/prvtxdb.plb    
SQL> exit

 

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close