Oracle:ORA-39006、ORA-39213解决办法
执行Oracle数据库导入,遇到报错ORA-39006: internal error、ORA-39213: Metadata processing is not available。这还是第一次遇到。
下面说下解决方法。
1. 执行导出操作,报错:
[oracle@oracle bin]$ ./expdp cwy_GX1009/cwy_GX1009@orcl directory=DATA_PUMP_DIR schemas=cwy_GX1009 dumpfile=cwy_GX1009_1028.dmp logfile=exp_cwy_GX1009_1028.log Export: Release 11.2.0.4.0 - Production on Fri Oct 28 13:56:36 2022 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.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
2. 解决办法:
sqlplus 执行 execute dbms_metadata_util.load_stylesheets;
[oracle@oracle bin]$ sqlplus /nolog SQL*Plus: Release 11.2.0.4.0 Production on Fri Oct 28 13:59:59 2022 Copyright (c) 1982, 2013, Oracle. All rights reserved. SQL> conn /as sysdba Connected. SQL> execute dbms_metadata_util.load_stylesheets; PL/SQL procedure successfully completed. SQL>
3. 再次导出,导出成功:
[oracle@oracle bin]$ ./expdp cwy_GX1009/cwy_GX1009@orcl directory=DATA_PUMP_DIR schemas=cwy_GX1009 dumpfile=cwy_GX1009_1028.dmp logfile=exp_cwy_GX1009_1028.log Export: Release 11.2.0.4.0 - Production on Fri Oct 28 14:01:51 2022 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "CWY_GX1009"."SYS_EXPORT_SCHEMA_01": cwy_GX1009/********@orcl directory=DATA_PUMP_DIR schemas=cwy_GX1009 dumpfile=cwy_GX1009_1028.dmp logfile=exp_cwy_GX1009_1028.log Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 724.5 MB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE
本文来自博客园,作者:查拉图斯特拉面条,转载请注明原文链接:https://www.cnblogs.com/n00dle/p/16836004.html