ORA-39213： Metadata processing is not available 解决方法

最新推荐文章于 2024-07-27 19:21:39 发布

转载最新推荐文章于 2024-07-27 19:21:39 发布 · 617 阅读

文章标签：

#oracle #数据库

oracle 专栏收录该内容

3 篇文章

订阅专栏

本文记录了在使用Oracle11.2.0.3进行impdp操作时遇到的ORA-39006和ORA-39213错误，并详细介绍了错误的解决过程。通过重新加载XSL样式表，成功解决了元数据处理不可用的问题，完成了数据导入。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Oracle 11.2.0.3 impdp 报错：

g2:/u01/backup> impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;

Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:35:19 2011
Copyright © 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is notavailable

查看ORA-39213 具体内容：

gg2:/u01/backup> oerr ora 39213

39213, 00000, “Metadata processing isnot 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 executedbms_metadata_util.load_stylesheets

// to reload the stylesheets.

gg2:/u01/backup>
运行脚本：
SQL> conn / as sysdba;
Connected.
SQL> execute sys.dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
再次impdp 成功：

gg2:/u01/backup> impdp dave/dave directory=backup dumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace;
Import: Release 11.2.0.3.0 - Production onWed Nov 16 12:39:40 2011
Copyright © 1982, 2011, Oracle and/or itsaffiliates. All rights reserved.
Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

Master table “DAVE”."SYS_IMPORT_TABLE_01"successfully loaded/unloaded

Starting"DAVE".“SYS_IMPORT_TABLE_01”: dave/******** directory=backupdumpfile=pdba.dmp logfile=table.log tables=pdba table_exists_action=replace

Processing object typeTABLE_EXPORT/TABLE/TABLE

Processing object typeTABLE_EXPORT/TABLE/TABLE_DATA

. . imported"DAVE".“PDBA” 49.14 MB 2713235rows

Job"DAVE".“SYS_IMPORT_TABLE_01” successfully completed at 12:40:16