执行Oracle数据库导入,遇到报错ORA-39006: internal error、ORA-39213: Metadata processing is not available。这还是第一次遇到。 下面说下解决方法。 1. 执行导出操作,报错: [oracle@oracle bin]$ ./expdp cwy_GX1009/cwy_GX1009@orcl directory=DATA_PUMP_DIR schemas=cwy_GX1009 dumpfile=cwy_GX1009_1028....
ORA-39006: internal error ORA-39213: Metadata processing is not available 1. 2. 初看到internal error的错误提示,下了一跳。Google一番的结果如下: Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly. Action: Connect ...
问题现象: expdp报如下错误 ORA-39006: internal error ORA-39213: Metadata processing is not available 参考metalink:Ora-39213 Using Data Pump Export (文档 ID 402242.1),执行如下语句: SQL> execute sys.dbms_metadata_util.load_stylesheets; 1. 2. 3. 4. 5. 6. 提示如下错误 begin dbms_metadata_uti...
当使用expdp命令进行Oracle数据库数据导出时，遇到了ORA-39006和ORA-39213错误。错误信息提示数据泵无法使用元数据API，通常原因是XSL样式表未正确设置。为解决此问题，需要作为SYSDBA连接并执行dbms_metadata_util.load_stylesheets过程来重新加载样式表。执行步骤如下：SQL> execute dbms_metadata_util.load_st...
在客户的oracle 10.2.0.1环境下要准备进行迁移数据库,但是执行EXPDP的时候提示报错ORA-39006: internal errorORA-39213: Metadata processing is notavailable&...
ORA-39006错误原因及解决办法 使用impdp导出数据时碰到ora-39006错误,错误提示如下所示: ORA-39006: internal error ORA-39213: Metadata processing is not available 初看到internal error的错误提示,下了一跳。Google一番的结果如下: Cause: The Data Pump could not use the Metadata API. Typically, this is ...
记一次遇到ORA-39006,ORA-39213的解决办法 在客户的oracle 10.2.0.1环境下要准备进行迁移数据库,但是执行EXPDP的时候提示报错 ORA-39006: internal error ORA-39213: Metadata processing is notavailable 使用ORACLE用户,查看ORA-39213 具体内容: oerr ora 39213...
With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39006: internal error ORA-39213: Metadata processing is not available 查询了一下,解决方法如下描述: Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being...
ORA-39006: internal error ORA-39213: Metadata processing is not available 查询了一下,解决方法如下描述: Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly.
ORA-39213: Metadata processing is not available 1. 2. 3. 4. 5. 6. 按照提示进行操作,解决问题: 根据oerr ora 39213提示,执行exec dbms_metadata_util.load_stylesheets; [oracle@data ~]$ sqlplus / as sysdba SQL*Plus: Release11.2.0.1.0 Production on Wed Feb509:59:262020Copyright(c)1982,2009...