expdp时出现错误:ORA-39006: internal error
[Oracle@ ~]$ 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
Copyright (c) 2003, 2005, Oracle. All rights reserved.
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@ ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 25 18:25:26 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> execute dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
,