My Oracle Support Banner

SUPPORT UTIL DELETES DATA FROM W_RTL_PARTITION_MAP_G FOR PARTITIONS IN W_RTL_ITEM_GRP1_D (Doc ID 2941799.1)

Last updated on APRIL 12, 2023

Applies to:

Oracle Retail Insights Cloud Service Suite - Version NA and later
Information in this document applies to any platform.

Symptoms

When Support util routines are used to truncate table W_RTL_ITEM_GRP1_D. The partition information also get's deleted from W_RTL_PARTITION_MAP_G.
The partitions in this dimension table cannot be dropped as the table holds list partitions which do not get extended or recreated via partition utility.

Hence, while truncating table W_RTL_ITEM_GRP1_D Support util should ignore dropping it's partitions or deleting partition information from W_RTL_PARTITION_MAP_G

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