Question: What do
I do to fix the ORA-39213 error when using expdp:
expdp system/manager dumpfile=dpump_dir:scott.dmp
It is giving below ORA-29213 error.
ORA-39213: Metadata processing is not
Answer: The oerr utility shows this
for the ORA-39213 error:
processing is not available.
The Data Pump could not use the Metadata API. Typically,
this is caused by the XSL stylesheets not being set up
Action: Connect AS SYSDBA
and execute dbms_metadata_util.load_stylesheets to reload
During the import, dbms_metadata_util.load_stylesheets
Oracle reads the directory at $ORACLE_HOME/rdbms/xml/xsl and
load the XSL files using DBMS_LOB package. If the files
cannot be read (with missing privileges for "oracle" user),
then we give the ORA-39213 error.
In Windows, we need to check the registry entries to
ensure that they are in a valid state. In case you
have INVALID status in dba_registry, we check it and try to
find a solution for it. In my case, the "CATPROC" registry
entry was invalid. To resolve this we run "CATPROC.sql" file
which is present in "$ORACLE_HOME/RDBMS/admin/" directory :
In UNIX/Linux, the fix is to perform these steps:
1 - chmod 755 the permissions on the directory:
2 - Re-load the stylesheets using the
In some cases the load_stylesheets procedure will fail
ORA-31609: error loading file "kualter.xsl"
from file system directory "/rdbms/xml/xsl"
at "SYS.DBMS_METADATA_UTIL", line 1807
This package needs XML being installed and
XML needs JAVA being installed. This select from view
dba_registry shows neither Java nor XML were installed:
SQL> select comp_id, version, status
Hence, we need to install JVM and XML executing the
SQL> connect /
SQL> connect / as sysdba
connect / as sysdba
SQL> connect / as sysdba
Oracle Training from Don Burleson
The best on site
training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!
Burleson is the American Team
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
is the registered trademark of Oracle Corporation.