从Oracle 11g impdp到Oracle 10g报错ORA-39213: Metadata processing
程序员文章站
2023-12-30 21:56:10
...
从Oracle 11g通过expdp方式指定version导出数据，导入Oracle10g时，报错：Copyright (c) 2003, 2005, Oracle. All rights reser
从Oracle 11g通过expdp方式指定version导出数据，导入Oracle10g时，，报错：
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining 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 set up properly.
Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.