Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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]
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms