Export Export encountered ORA-19206 EXP-56 While Taking export, ora-19206exp-56
Applies to: Oracle Database-Enterprise Edition-Version 9.2.0.1 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.
*** Checked for relevance on 11-Apr-2013 ***
Symptoms
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
The error ORA-600 [qmxtrGetInputOpn1] may occur.
Cause
XDB installation/dictionary built causes some of the underlying XML views to be INVALID. The error occurs when dbms_xmlgen tries to access one those invalid views.
Solution
-Upgrade to 10g where the issue is fixed.
Or:
-Remove XDB component, if you are not using it. The steps are described in:
Note 1292089.1-Master Note for Oracle XML Database (XDB) Install/Deinstall
Note:A possible workaround is turning off query rewrite for XML operators by setting the following event:
SQL> alter system set events '19027 trace name context forever, level 1 ';
To disable the event at any time
SQL> alter system set events '19027 trace name context off ';