Shulou(Shulou.com)06/01 Report--

How to solve the expdp export error ORA-39006 and ORA-39213, I believe that many inexperienced people are helpless about this, this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

The following error is reported when exporting expdp:

Export: Release 11.2.0.1.0 - Production on Wed Feb 5 09:55:13 2020Copyright (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 ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-39006: internal errorORA-39213: Metadata processing is not available

Follow the prompts to solve the problem:

exec dbms_metadata_util.load_stylesheets according to oerr ora 39213 prompt;

[oracle@data ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 5 09:59:26 2020Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> execute dbms_metadata_util.load_stylesheets;PL/SQL procedure successfully completed.SQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options

The problem is solved after normal export.

After reading the above, do you know how to solve the expdp export error ORA-39006 and ORA-39213? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.