Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 7.968 GB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE >>> DBMS_AW_EXP: BIN$DdyrY/cyAMLgU5/YLVaAbg==$0 not AW$
Solution: empty the recyclebin:
purge dba_recyclebin;and restart the export.
DBMS_AW_EXP: Ignoring APPS.ODPCODE During Schema Data Pump Export (Doc ID 1675617.1)
ReplyDeleteClick to add to Favorites DBMS_AW_EXP: Ignoring APPS.ODPCODE During Schema Data Pump Export (Doc ID 1675617.1) To BottomTo Bottom
In this Document
Symptoms
Changes
Cause
Solution
References
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
APPLIES TO:
Oracle OLAP - Version 11.2.0.4 and later
Information in this document applies to any platform.
SYMPTOMS
When attempting to perform a schema level export with datapump post database upgrade to 11.2.0.4,
the following information is logged in the export log:
expdp userid/password schemas=AP dumpfile=ap_expdp.dmp logfile=ap_expdp.log
-----------------------
>>> DBMS_AW_EXP: Ignoring FPA.FPAPJP
>>> DBMS_AW_EXP: Ignoring APPS.ODPCODE
>>> DBMS_AW_EXP: Ignoring ZPB.ZPBCODE
>>> DBMS_AW_EXP: Ignoring APPS.XWDEVKIT
You will also notice the AWs are actually exported:
Processing object type SCHEMA_EXPORT/ASSOCIATION
. . exported "APPS"."SUB_GIR" 79.72 MB 3675245 rows
. . exported "APPS"."AW$ODPCODE":"PTN1"."SYS_SUBP101" 38.13 MB 135 rows
. . exported "APPS"."OE_ITEMS_MV" 31.12 MB 270575 rows
. . exported "APPS"."AW$$TEMP_EXP_TABLE112" 14.32 MB 7197 rows
. . exported "APPS"."AW$XWDEVKIT":"PTN1"."SYS_SUBP226" 7.930 MB 147 rows
. . exported "APPS"."AW$ODPCODE":"PTNN"."SYS_SUBP116" 5.279 MB 199 rows
. . exported "APPS"."AW$ODPCODE":"PTNN"."SYS_SUBP109" 4.294 MB 165 rows
. . exported "APPS"."AW$ODPCODE":"PTNN"."SYS_SUBP110" 4.893 MB 159 rows
. . exported "APPS"."AW$ODPCODE":"PTNN"."SYS_SUBP111" 4.441 MB 181 rows
. . exported "APPS"."AW$ODPCODE":"PTNN"."SYS_SUBP113" 4.578 MB 153 rows
. . exported "APPS"."AW$ODPCODE":"PTNN"."SYS_SUBP112" 4.225 MB 165 rows
. . exported "APPS"."AW$ODPCODE":"PTNN"."SYS_SUBP114" 4.255 MB 154 rows
. . exported "APPS"."AW$ODPCODE":"PTNN"."SYS_SUBP115" 4.279 MB 173 rows
CHANGES
Upgrade to 11.2.0.4
CAUSE
In 11.2.0.4, we provide more details than we did in11.2.0.3.
SOLUTION
These messages can be ignored. AWs can't be exported like regular tables since they contain binary structures on disk that are not stored in an architecture-independent manner. So the datapump product provides a way for database options like OLAP to register special callbacks so we can handle our own objects (in this case AWs) appropriately. Unfortunately even when you export a single schema, our callback gets called for each AW in the instance. So that accounts for the messages about AWs not in the schema to export. Once you import the dump file, you will notice all the AWS are there.
purge dba_recyclebin; helped me in my case... Thanks allot...
ReplyDeletepurge dba_recyclebin; helped me in my case
ReplyDelete