ORA-39006错误原因及解决办法

使用impdp导出数据时碰到ora-39006错误，错误提示如下所示：

?

1 2	ORA-39006: internal error ORA-39213: Metadata processing is not available

初看到internal error的错误提示，下了一跳。Google一番的结果如下：

?

1 2	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 execute dbms_metadata_util.load_stylesheets to reload the stylesheets.

数据泵无法使用元数据API，需要以sysdba身份登录，执行：

?

1 2	SQL> execute dbms_metadata_util.load_stylesheets; PL/SQL procedure successfully completed.