expdp导出数据报ORA-39006， ORA-39213

错误信息：

ORA-39006: internal error

ORA-39213: Metadata processing is not available

解决办法：

[oracle@dbServer ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 17 20:04:16 2021

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

SQL> conn / as sysdba
Connected.
SQL> sys.dbms_metadata_util.load_stylesheets;
SP2-0734: unknown command beginning "sys.dbms_m..." - rest of line ignored.
SQL> execute  sys.dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.

SQL> \q

执行结果成功，

[oracle@dbServer ~]$ expdp system/oracle@orcl directory=dump_dir dumpfile=book.dmp tablespaces=tbs_book

Export: Release 11.2.0.1.0 - Production on Sun Jan 17 20:05:25 2021

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
Starting "SYSTEM"."SYS_EXPORT_TABLESPACE_01":  system/********@orcl directory=dump_dir dumpfile=book.dmp tablespaces=tbs_book 
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 256 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "USERBOOK"."BOOKS"                          6.945 KB      10 rows
. . exported "USERBOOK"."ITEMS"                          8.289 KB      19 rows
. . exported "USERBOOK"."ORDERS"                         5.539 KB      11 rows
. . exported "USERBOOK"."USERINFO"                       6.289 KB       3 rows
Master table "SYSTEM"."SYS_EXPORT_TABLESPACE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLESPACE_01 is:
  /data/dump/book.dmp
Job "SYSTEM"."SYS_EXPORT_TABLESPACE_01" successfully completed at 20:05:33

引用：https://blog.csdn.net/qq_41793064/article/details/104978825

posted on 2021-01-17 20:42  wtsgtc  阅读(380)  评论(0)  编辑  收藏  举报

导航