Home > Database > Mysql Tutorial > expdp时出现错误:ORA-39006: internal error

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

WBOY
Release: 2016-06-07 17:26:15
Original
2635 people have browsed it

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

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template