Export exports encountered ORA-19206 EXP-56 while taking export

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

Also 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.

Pre

-Remove XDB component, if you is not using it. The steps is 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 ';

Export exports encountered ORA-19206 EXP-56 while taking export