My Oracle Support Banner

OBIA 7964 Index Not Getting Dropped During Before SIL Load Of W_MFG_OPERATION_DETAIL_F (Doc ID 1610928.1)

Last updated on AUGUST 19, 2019

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

When loading the Target W_MFG_OPERATION_DETAIL_F table from Staging, the Indices on the table are not getting dropped before load. As a result, it is taking a very long time for this load to complete. The "Always Drop and Recreate BitMap" check box is checked in DAC. The drop and create index is also set in the Execution Plan.

This happens only with this target table. The indices are getting dropped in the case of other target table loads.

Changes

 

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


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