Introduction:- In this article we will learn how to resolve the ORA 39213 metadata processing is not available error while trying to export the table in oracle using dataPump utility.
Using Datapump utility we can export/import any database objects in oracle. While doing the facing error ORA 39213 metadata processing.
Exporting table using DataPump.
$expdp apps/apps tables=EMP_POLICY_MASTER directory=apps_dir dumpfile=EMP_POLICY_MASTER.dmp logfile=expdpEMP_POLICY_MASTER.log
Export: Release 11.2.0.4.0 – Production on Sat Feb 20 14:08:58 2021
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
This error can be detected while executing the DataPump in any platform. You may get this error during expdp or impdp.
For solution, execute sys.dbms_metadata_util.load_stylesheets to fix this problem as below.
SQL> execute sys.dbms_metadata_util.load_stylesheets;
You can see here we have resolved the issue.. Now we will retest the same datapump commands.
Retest the issue.
$expdp apps/apps tables=EMP_POLICY_MASTER directory=apps_dir dumpfile=EMP_POLICY_MASTER.dmp lfile=expdpEMP_POLICY_MASTER.log
Export: Release 11.2.0.4.0 – Production on Sat Feb 20 14:36:58 2021
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
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: “file=expdpEMP_POLICY_MASTER1.log” Location: Command Line, Replaced with: “dumpfile=expdpEMP_POL ICY_MASTER1.log”
Legacy Mode has set reuse_dumpfiles=true parameter.
Starting “APPS”.”SYS_EXPORT_TABLE_01″: apps/******** tables=EMP_POLICY_MASTER directory=apps_dir dumpfile=EMP_POLICY_M ASTER1.dmp dumpfile=expdpEMP_POLICY_MASTER1.log reuse_dumpfiles=true
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 256 KB
>>> DBMS_AW_EXP: Ignoring FPA.FPAPJP
>>> DBMS_AW_EXP: Ignoring APPS.ODPCODE
>>> DBMS_AW_EXP: Ignoring APPS.XWDEVKIT
Processing object type TABLE_EXPORT/TABLE/TABLE
>>> DBMS_AW_EXP: Ignoring FPA.FPAPJP
>>> DBMS_AW_EXP: Ignoring APPS.ODPCODE
>>> DBMS_AW_EXP: Ignoring APPS.XWDEVKIT
Processing object type TABLE_EXPORT/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type TABLE_EXPORT/TABLE/POST_INSTANCE/PROCDEPOBJ
. . exported “APPS”.”EMP_POLICY_MASTER” 146.5 KB 1310 rows
Master table “APPS”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for APPS.SYS_EXPORT_TABLE_01 is:
/data05/apps_dir/EMP_POLICY_MASTER1.dmp
Job “APPS”.”SYS_EXPORT_TABLE_01″ successfully completed at Sat Feb 20 14:37:37 2021 elapsed 0 00:00:38
Successfully completed the job……
For more information regarding datapump, you may check the another article , here.
If you want to check the another article for same error, you may click here.