DBMS_AW_EXP: Ignoring APPS.ODPCODE During Schema Data Pump Export (Doc ID 1675617.1)

Last updated on FEBRUARY 04, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.