Fix IMPDP ORA-39006 ORA-39213

advertisements

_____________________________________________________________________________________________________________________

Problem Description:

Impdp failed with following error message

[oracle]$ impdp  DIRECTORY=dmp_dir DUMPFILE=exp.dmp LOGFILE=imp.log REMAP_SCHEMA=source:target

Import: Release 12.1.0.2.0 - Production on Fri Sep 2 04:39:17 2016


Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is not available

Solution description: 

Connect to sqlplus as sysdba and execute following package. It will resolve your issue.

SQLPLUS  / AS SYSDBA
SQL> execute sys.dbms_metadata_util.load_stylesheets;


PL/SQL procedure successfully completed.

_____________________________________________________________________________________________________________________

Website Stats