Last updated on JUNE 13, 2013
Applies to:Oracle Server - Enterprise Edition - Version: 22.214.171.124.0
This problem can occur on any platform.
Encountring Ora-07445 Klclixi and ORA-600 16159 interchangably.
Below statment is failing evertime from the sql prompt.
INSERT /*+ APPEND */ INTO TRANSACTION_TENDER SELECT TRANSACTION_IDENTIFIER,
TENDER_LINE_ITEM_NUMBER, STORE_KEY, EDW_BUSINESS_BRAND_CODE, GROUP_LOYALTY_LICENSEE_CODE,
TRANSACTION_DATE, STORE_IDNT, TRANSACTION_NUMBER, CONCAT_HOUR_MINUTE_NBR,...............
The involved table that the error applies to has thousands of subpartitions, each index is local and has thousands partitions. Few indexes are bitmapped.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms