My Oracle Support Banner

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

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
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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