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
Thanks very much for this tip, Francisco. It saved me much worry and hair pulling.
Dear Erika,
You are welcome, I’m glad that this note helped you with your problem!
Kind Regards,
Francisco Munoz Alvarez
Dear where we should run this script………please let me know….
Hi Ali, sorry did not understand your question. Can you please be more specific? Are you asking what tool to use to connect to the database and run the script?
Regards,
Francisco
I am being used PL/SQL developer to connect with database
That script is part of the database in the server side. If you want to run it from the client you will need to upload to your laptop that scrip from a database installation (or download And install Oracle on your laptop or VM)
Dear i have installed oracle 10g with 6i reports and form builder and to access database i am being used PL/sql Developer tool.
by using pl/sql developer i connect with database (STOCK/GUJJAR@UMER). I connect user “stock” as “sysdba” and run your script and script has run successfully but my problem still persist……..please help me