_____________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment