My Oracle Support Banner

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

Last updated on JULY 16, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.