ORA-39213: Metadata processing is not available

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.

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..

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......