if you face an error like the following while performing “impdp” operations:

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit 
Production
With the Partitioning, OLAP and Data Mining options
ORA-39006: internal error
ORA-39213: Metadata processing is not available

 

Solution:

execute the following command:

SQL> exec dbms_metadata_util.load_stylesheets;

if the above query executes sucessfully then try the “impdp” command again.

other wise if you face the below:

SQL> exec dbms_metadata_util.load_stylesheets;

BEGIN dbms_metadata_util.load_stylesheets; END;
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEEXISTs failed
Permission denied
ORA-06512: at “SYS.DBMS_METADATA_UTIL”, line 1807
ORA-06512: at line 1

During dbms_metadata_util.load_stylesheets we read the directory $ORACLE_HOME/rdbms/xml/xsl and load the XSL files using DBMS_LOB package.

If the files cannot be read (most of cases by missing rwx privileges for oracle user), then we raise the errors above.

Re-load the stylesheets using the dbms_metadata_util.load_stylesheets procedure after the permission issue is solved and then retry DataPump import (impdp).

you may need to install Install JVM and XML components.