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

Advertisements

Oracle ACE Director and President of LAOUC, NZOUG and CLOUG. Organizer of LA and APAC OTN Tours,

Posted in General, Oracle FAQ
2 comments on “How to solve the error “EXP-00056: ORACLE error 19206″ during an export
  1. Erica Harris says:

    Thanks very much for this tip, Francisco. It saved me much worry and hair pulling.

  2. admin says:

    Dear Erika,

    You are welcome, I’m glad that this note helped you with your problem!

    Kind Regards,

    Francisco Munoz Alvarez

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: