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 18.104.22.168 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