expdp时出现错误：ORA-39006: internal error

来源：互联网发布：眼镜店进销存软件编辑：程序博客网时间：2024/05/18 00:34

[oracle@www.52uu.org ~]$ expdp admin/admin tables=studentinfo,teacherinfo DIRECTORY=dpump_dir3 dumpfile=info.dmp content=all

Export: Release 10.2.0.1.0 - Production on Tuesday, 25 May, 2010 18:23:02

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39213: Metadata processing is not 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 execute dbms_metadata_util.load_stylesheets to reload the stylesheets.

执行如下：

[oracle@www.52uu.org ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Tue May 25 18:25:26 2010Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> execute dbms_metadata_util.load_stylesheets;PL/SQL procedure successfully completed.