当前位置:  数据库>oracle

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

    来源: 互联网  发布时间:2017-05-16

    本文导语: [Oracle@ www.linuxidc.com ~]$ 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 Ente...

[Oracle@ www.linuxidc.com ~]$ 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@ www.linuxidc.com ~]$ 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.


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • 基于oracle expdp命令的使用详解


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,