今天在用expdp导出数据时报告一下错误,很奇怪,我的操作步骤没有错误啊。
ORA-39006: internal error
ORA-39213: Metadata processing is not available
以下是我解决错误的相关信息
操作系统:
Linux infodb111.com 2.6.9-42.0.0.0.1.ELsmp #1 SMP Sun Oct 15 14:02:40 PDT 2006 i686 i686 i386 GNU/Linux
数据库版本信息:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
以下是操作步骤:
[root@infodb111 ~]# su - oracle
[oracle@infodb111 /]$ mkdir /oracle/dump_dir
[oracle@infodb111 /]$ sqlplus / as sysdba
SQL> create directory dump_dir as '/oracle/dump_dir';
SQL> grant read,write on directory dump_dir to scott;
Grant succeeded.
[oracle@infodb111 /]$ expdp scott/scott tables=mevent directory=dump_dir dumpfile=dump1.dmp
Export: Release 10.2.0.4.0 - Production on Wednesday, 26 May, 2010 11:02:10
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is not available
[oracle@infodb111 /]$ oerr ora 39006
39006, 00000, "internal error"
// *Cause: An unexpected error occurred while processing a Data Pump job.
// Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS
// will further describe the error.
// *Action: Contact Oracle Customer Support.
[oracle@infodb111 /]$ oerr ora 39213
39213, 00000, "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.
根据oerr ora 39213提示,执行exec dbms_metadata_util.load_stylesheets;
再进行导出正常,问题解决。