impdp directory=expdp_dir dumpfile=zhdb3.dmp logfile=zhdb.log

mport: 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> exec dbms_metadata_util.load_stylesheets;


PL/SQL procedure successfully completed.