ORA-7445 [kkpobifd_build_idx_frag_descrs], ORA-7445 [ainPSplit] Or ORA-600 [aindp1] Using ALTER TABLE SPLIT / MERGE PARTITION

(Doc ID 1354414.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

You have 2 partitionned tables: a first table (parent) is partitionned "by range" and the second one (child) is partitionned "by reference".
You have then, 2 sessions in which you are trying to do two different tasks on the parent table:

in session #1, you are dropping one partition (P3) by calling the following SQL command:
SQL> alter table parent drop partition p3 update global indexes;

and in session #2, your attempt to split another partition (P4):
SQL> alter table parent split partition p4 at (3500000) into (partition p4, partition p5) update global indexes;

systematically fails with
ORA-03113
ORA-07445: exception encountered: core dump [kkpobifd_build_idx_frag_descrs()+2157]

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