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