虚位以待(AD)
虚位以待(AD)
首页 > 数据库 > Oracle数据库 > ORA-39006,ORA-39213,ORA-06512,ORA-01114,ORA-39065,ORA-39097,ORA-01403EXPDP报错问

ORA-39006,ORA-39213,ORA-06512,ORA-01114,ORA-39065,ORA-39097,ORA-01403EXPDP报错问
类别:Oracle数据库   作者:码皇   来源:ORA-39006,ORA-39213,ORA-06512,ORA-01114,ORA-39065,ORA-39097,ORA-01403 EXPDP报错问题处理     点击:

问题现象:?expdp报如下错误?ORA-39006: internal errorORA-39213: Metadata processing is not available参考metalink:Ora-39213 Using Data Pump Export (文档 ID 402242 1),执行如下语句
问题现象:
    expdp报如下错误ORA-39006: internal errorORA-39213: Metadata processing is not available参考metalink:Ora-39213 Using Data Pump Export (文档 ID 402242.1),执行如下语句:SQL> execute sys.dbms_metadata_util.load_stylesheets;
提示如下错误
    begin dbms_metadata_util.load_stylesheets;
    end;
    ORA-01114: IO error writing block to file (block #)ORA-06512: at "dbms_metadata_util",line 2345ORA-06512: at line 2
解决办法:
    正确的如下,没有报错。execute dbms_metadata_util.load_stylesheets;
    再次执行expdp报如下错误:ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01403: no data found ORA-39097: Data Pump job encountered unexpected error 100执行执行如下脚本,重新生成DATAPUMP AIP即可:sqlplus / as sysdba SQL>@$ORACLE_HOME/rdbms/admin/catmeta.sql SQL>@$ORACLE_HOME/rdbms/admin/catmet2.sql SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql
相关热词搜索: 问题