Data Pump Export Loops on Nested Tables After Applying Patch 8540412 on Unix/Linux Or The 11.1.0.7 Patch 15 on Windows (Doc ID 984167.1)

Last updated on MAY 06, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms

After applying patch 8540412 on Unix / Linux platforms OR after applying the 11.1.0.7 Patch 15 or higher on Windows , it is seen that during exports, nested tables loop.

For example, you will see similar to the following during a full export:

. . exported "SYSMAN"."PARAM_VALUES_TAB" 14.92 KB 466 rows
. . exported "SYSMAN"."PARAM_VALUES_TAB" 14.92 KB 466 rows
. . exported "SYSMAN"."PARAM_VALUES_TAB" 14.92 KB 466 rows
. . exported "SYSMAN"."PARAM_VALUES_TAB" 14.92 KB 466 rows
. . exported "SYSMAN"."PARAM_VALUES_TAB" 14.92 KB 466 rows
. . exported "SYSMAN"."PARAM_VALUES_TAB" 14.92 KB 466 rows

....
....
.. exported "SYSMAN"."MGMT_DELTA_SUMMARY_ERRORS" 0 KB 0 rows
.. exported "SYSMAN"."MGMT_DELTA_SUMMARY_ERRORS" 0 KB 0 rows

 

However, the same looping can occur on any nested table.

Changes

Applied the 8540412 on Unix / Linux platforms.

OR

Applied the 11.1.0.7 Patch 15 or higher patch on the Windows platforms

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms