Fix IMPDP ORA-39006 ORA-39213

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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google