Split Subpartition Fails with ORA-7445 [Kkpogmcrp_generate_multi_column_range_predicates] (Doc ID 756413.1)

Last updated on OCTOBER 21, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.8 - Release: 11.1 to 11.1

Symptoms

1. The following errors are reported in the alert.log:


Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x4] [PC:0x326C91F,
_kkpogmcrp_generate_multi_column_range_predicates()+195]

Errors in file c:\oracle\diag\rdbms\trace\SID_ora_3248.trc (incident=20299):

ORA-07445: exception encountered: core dump [kkpogmcrp_generate_multi_column_range_predicates()+195] [ACCESS_VIOLATION] [ADDR:0x4]
[PC:0x326C91F] [UNABLE_TO_READ] []

2. There may be a current SQL reported in the trace file:

ORA-07445: exception encountered: core dump [kkpogmcrp_generate_multi_column_range_predicates()+195] [ACCESS_VIOLATION] [ADDR:0x4] [PC:0x326C91F] [UNABLE_TO_READ] []

----- Current SQL Statement for this session

ALTER TABLE HUBBES.TPOSBSD_NOVO
SPLIT SUBPARTITION P_0007_20080101_MAX
AT (TO_DATE('20080102', 'YYYYMMDD'))
INTO ( SUBPARTITION P_0007_20080101_20080101, SUBPARTITION P_0007_20080101_MAX)

3. The call stack will resemble:

kkpogmcrp_generate <- multi_column_range <- predicates <- kkpoFMCheckValuesR <- ange <- ctccffs <- VInfreq__ctcdrv <- opiexe <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- opimai <- OracleThreadStart


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