姓名：杨宝秋，OCM，ACE。近8年的TB级数据库设计、建设、管理、运行维护、调优经验，也做了7年的Hp和IBM Rs6000的系统管理员，而且是获得了BCFP认证的SAN管理员，现为中国联通黑龙江分公司数据库主管。
ORA-19206 EXP-00056 While Taking Export
上一篇 /
下一篇 2008-01-31 08:14:33
/ 个人分类：Oracle
ORA-19206 EXP-00056 While Taking Export Metalink:206313.1
Oracle Server Version 9.2.0.1
Export Version 9.2.0.1
Symptom:
---------
During export you receive the following errors:
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
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.
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
