ORA-39213: Metadata processing is not available solution

 

Oracle 11.2.0.3 impdp error:

 

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,201 1, Oracle and/or itsaffiliates. All rights reserved.

 

Connected to: Oracle Database 11 gEnterprise 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.

 

View ORA-39213 details:

Gg2:/u01/backup> oerr ora 39213

39213,000 00, "Metadata processing isnot available"

// * Cause: The Data Pump cocould 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>

 

Run the script:

SQL> conn/as sysdba;

Connected.

SQL> executesys. dbms_metadata_util.load_stylesheets;

 

PL/SQL procedure successfully completed.

 

Impdp again:

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,201 1, Oracle and/or itsaffiliates. All rights reserved.

 

Connected to: Oracle Database 11 gEnterprise 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

Processing object typeTABLE_EXPORT/TABLE/TABLE_DATA

.. Imported "DAVE". "PDBA" 49.14 MB 2713235 rows

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

 

 

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