My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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