ORA-39213: Metadata processing is not available

expdp 出现异常

 

 

$expdp system/oracle directory=dumpdir dumpfile=ora10.dmp full=y

 

Copyright (c) 1982, 2011, Oracle and/or itsaffiliates.  All rights reserved.

 

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

 

再次expdp成功

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24849178/viewspace-750541/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24849178/viewspace-750541/