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 OCTOBER 01, 2019

Applies to:

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


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.




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

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