Oracle Spin

Day-to-Day Experiences

« Setting NLS_LANG for Oracle
Internal parameters »

ORA-19206 when running export (exp)

Posted by Amin Jaffer on May 8, 2008

On Oracle9i if you get the following error when running export (exp) utility, to fix this issue one would need to run the $ORACLE_HOME/rdbms/admin/catmeta.sql as sys to fix this issue.

About to export SYSTEM’s objects …
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
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

This entry was posted on May 8, 2008 at 4:39 pm and is filed under Export. Tagged: , , . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “ORA-19206 when running export (exp)”

  1. Yogesh V Dhongade said

    August 26, 2008 at 5:40 am

    Thanks Amin,

    I never faced such situation even working for so long in oracle 9. Thanks for the important information. I thought I was stuck, but you r post helped me.

    Thanks again !!!

    Cheers’
    Yogesh V Dhongade

    Reply

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

« Setting NLS_LANG for Oracle
Internal parameters »