Interchangably Encountering Ora-07445 Klclixi and ORA-600 [16159] (Doc ID 313248.1)

Last updated on JUNE 13, 2013

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.6.0
This problem can occur on any platform.

Symptoms

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms