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 22.214.171.124 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