oracle19206,ORA-19206 EXP-00056 While Taking Export

ORA-19206 EXP-00056 While Taking Export Metalink:206313.1[@more@]

Oracle Server Version 9.2.0.1

Export Version 9.2.0.1

Symptom:

---------

During export you receive the following errors:

EXP-00056: ORACLE error 19206 encountered

ORA-19206: Invalid value for query or REF CURSOR parameter

ORA-06512: at "SYS.DBMS_XMLGEN", line 83

ORA-06512: at "SYS.DBMS_METADATA", line 345

ORA-06512: at "SYS.DBMS_METADATA", line 410

ORA-06512: at "SYS.DBMS_METADATA", line 449

ORA-06512: at "SYS.DBMS_METADATA", line 1156

ORA-06512: at "SYS.DBMS_METADATA", line 1141

ORA-06512: at line 1

EXP-00056: ORACLE error 19206 encountered

EXP-00000: Export terminated unsuccessfully

Cause:

------

XDB installation/dictionary built causes some of the underlying XML views to be INVALID.

Here the error occurs when dbms_xmlgen tries to access one those invalid views.

Fix:

----

Run the following script that resides under

$ORACLE_HOME/rdbms/admin directory after XDB dictionary is built

by connecting as user SYS :

catmeta.sql (Creates Object Model of Oracle dictionary)

After running this script, start the export of database again.