Fix IMPDP ORA-39006 ORA-39213


The Eucharistic Miracles of the World
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 - 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 - 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.

SQL> execute sys.dbms_metadata_util.load_stylesheets;

PL/SQL procedure successfully completed.


Website Stats


Post a Comment


Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer