使用impdp导出数据时碰到ora-39006错误,错误提示如下所示: 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 ...
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 caused by the XSL stylesheets not being set up properly. Action: Connect AS SYSDBA...
执行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....
1.从报错信息ORA-39006: internal error来看只能看出是ORACLE内部错误,看不出其它的问题。一般情况下抛ORA-39006错误的同时紧跟还会有一个其它的报错,则好好定位问题。正因为没有抛出第二个错,我们可以想像到有可能不是数据库本身的问题,是操作系统的问题,从而数据库抓不到相应更细的报错。 2.非windows操作系统通过...
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. 提示如下错误 ...
expep/Impdp导入时报错：ORA-39006: internal error ORA-39213:Metadata processing is not available 解决：execute dbms_metadata_util.load_stylesheets;
记一次遇到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...
When dbms_datapump.add_file is called by command line export or datapump API, it fails with:ORA-39006: internal errorORA-06512: at "SYS.DBMS_SYS_ERROR", line 79ORA-06512: at "SYS.DBMS_DATAPUMP", line 3507ORA-06512: at "SYS.DBMS_DATAPUMP", line 3756ORA-06512: at line 11...
在客户的oracle 10.2.0.1环境下要准备进行迁移数据库,但是执行EXPDP的时候提示报错ORA-39006: internal errorORA-39213: Metadata processing is notavailable&...
ORA-39006错误原因及解决办法 expep/Impdp导入时报错: ORA-39006: internal error ORA-39213:Metadata processing is not available 解决: execute dbms_metadata_util.load_stylesheets;