My Oracle Support Banner

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:

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


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-07445: exception encountered: core dump [kkpobifd_build_idx_frag_descrs()+2157]


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

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