본문 : http://www.ischo.net -- 조인상 //시스템 엔지니어

+++++++++++++++++++++++++++++++++++++++++++++++++++++++


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





====> 해결방법

Cause:

------



XDB installation/dictionary built causes some of the underlying XML views to be INVALID. 

Here the error occurs when dbms_xmlgen tries to access one those invalid views.





Fix:

----



Run the following script that resides under 

$ORACLE_HOME/rdbms/admin directory after XDB dictionary is built

by connecting as user SYS :



catmeta.sql (Creates Object Model of Oracle dictionary) 



After running this script, start the export of  database again.