首頁 >資料庫 >mysql教程 >expdp时出现错误:ORA-39006: internal error

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

WBOY
WBOY原創
2016-06-07 17:26:152636瀏覽

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.

linux

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn