How to solve the error “EXP-00056: ORACLE error 19206″ during an export

If you see the error EXP-00056 with Oracle error 19206 (like show bellow) when executing a export of an entire schema in Oracle 9i or 10g, don’t panic. The solution is easy.

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
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-00000: Export terminated unsuccessfully

This problem happens when the metadata tables needed to perform an export are missing or invalid and can sometimes occur when you dropped or modified the XMLDB schema or due to an upgrade.

The solution is very easy, like I said before. Just run the catmeta.sql scrip located at ”$ORACLE_HOME/rdbms/admin/catmeta.sql” when connected as sysdba, and the problem will be fixed.

Cheers,

Francisco Munoz Alvarez

2 thoughts on “How to solve the error “EXP-00056: ORACLE error 19206″ during an export

Leave a Reply