I faced “ORA-39213: Metadata processing is not available” error during data pump import as below.
impdp “‘/ as sysdba'” directory=EXPORT dumpfile=RTLS_FULL_10-09-2018_GECIS.DMP full=Y logfile=RTLS_FULL_IMP_10-09-2018_GECIS.LOG cluster=no parfile=imp.par
Import: Release 184.108.40.206.0 – Production on Mon Sep 10 15:45:29 2018
Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Standard Edition Release 220.127.116.11.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management 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.
#sqlplus / as sysdba
SQL> execute sys.dbms_metadata_util.load_stylesheets;
One thought on “Ora-39213 Using Data Pump Import/Export”