首页 > 数据库 > mysql教程 > expdp时出现错误:ORA-39006: internal error

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

WBOY
发布: 2016-06-07 17:26:15
原创
2639 人浏览过

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

来源:php.cn
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板