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 FEBRUARY 03, 2019

Applies to:

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

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