💡 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 12.1.0.2.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 12.1.0.2.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
ORA-39006: internal error
ORA-39213: Metadata processing is not available

🚢 Solution

#sqlplus / as sysdba

SQL> execute sys.dbms_metadata_util.load_stylesheets;