Home >Database >Mysql Tutorial >impdp导入数据无权限ORA-39213错误

impdp导入数据无权限ORA-39213错误

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 17:09:231234browse

Oracle@linux:~gt; impdp tbs/tbs directory=dmpdir dumpfile=20110810.dmp Import: Release 11.2.0.1.0 - Production on Sat D

Oracle@linux:~> impdp tbs/tbs directory=dmpdir dumpfile=20110810.dmp

Import: Release 11.2.0.1.0 - Production on Sat Dec 31 11:36:18 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is not available

oracle@linux:~> 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.
oracle@linux:~> sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 31 11:39:51 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> exec dbms_metadata_util.load_stylesheets

PL/SQL procedure successfully completed.

ok....

linux

Statement:
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