Error ORA-00001 With Alter Table Exchange Partition Update Global Indexes Parallel (Doc ID 1309820.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

While exchanging partition using PARALLEL option but the operation fails with:

SQL> alter table partesta exchange partition P_2 with table partestb including indexes without validation update global indexes parallel 4;
alter table partesta exchange partition P_2 with table partestb including indexes without validation update global indexes parallel 4
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-12801: error signaled in parallel query server P008
ORA-00001: unique constraint (USER.PK_PARTESTA) violated

This doesn't happen without the parallel option:

SQL> alter table partesta exchange partition P_2 with table partestb including indexes without validation update global indexes;

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