Issue: Export: Release 11.2.0.3.0 - Production on Wed Sep 30 19:44:23 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is not available
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39213: Metadata processing is not available
Solution:
Verify if all the components in the database are valid.
SQL> SELECT comp_id, version, status FROM dba_registry;
COMP_ID VERSION STATUS
------------------------------ ------------------------------ -----------
OWB 11.2.0.1.0 VALID
APEX 3.2.1.00.10 VALID
EM 11.2.0.3.0 VALID
AMD 11.2.0.3.0 VALID
SDO 11.2.0.3.0 VALID
ORDIM 11.2.0.3.0 VALID
XDB 11.2.0.3.0 VALID
CONTEXT 11.2.0.3.0 VALID
EXF 11.2.0.3.0 VALID
RUL 11.2.0.3.0 VALID
OWM 11.2.0.3.0 VALID
CATALOG 11.2.0.3.0 VALID
CATPROC 11.2.0.3.0 VALID
JAVAVM 11.2.0.3.0 VALID
XML 11.2.0.3.0 VALID
CATJAVA 11.2.0.3.0 VALID
APS 11.2.0.3.0 VALID
XOQ 11.2.0.3.0 VALID
Run the below statement and retest the issue.
SQL> execute dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
SQL> exit
expdp parfile=expdp_cltp_tables.par
Export: Release 11.2.0.3.0 - Production on Wed Sep 30 19:47:32 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."CLTB_TABLES_EXP": /******** AS SYSDBA parfile=expdp_cltp_tables.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3.375 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "GFCPROD"."CLTB_EVENT_ENTRIES":"SYS_P369" 1.278 MB 4788 rows
. . exported "GFCPROD"."CLTP_ACCOUNT_SCHEDULES":"SYS_P378" 327.8 KB 2383 rows
. . exported "GFCPROD"."CLTB_ACCOUNT_APPS_MASTER":"FUNDED" 296.3 KB 281 rows
. . exported "GFCPROD"."CLTP_ACCOUNT_COMP_BALANCES":"SYS_P371" 53.75 KB 785 rows
. . exported "GFCPROD"."CLTP_ACCOUNT_COMP_SCH":"SYS_P374" 63.08 KB 418 rows
. . exported "GFCPROD"."CLTP_ACCOUNT_COMP_SCH":"SYS_P375" 61.03 KB 398 rows
The issue should resolve.
No comments:
Post a Comment