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

2014-11-24 09:21:05 · 作者: · 浏览: 0

Oracle 11.2.0.3 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:35:19 2011

Copyright (c) 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> executesys.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 (c) 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

Blog: http://blog.csdn.net/tianlesoftware