Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12801: error signaled in parallel query server P007

KunwarNov 10 2010 — edited Nov 10 2010

Hi friends,
I am running a update on a big table with parallel clause.
I got the below error.Can someone help what should i next? This query takes a long time to execute(nearly 1 hour).
I searched on google and metalink but no success yet.

=======
ORA-12801: error signaled in parallel query server P007
ORA-00001: unique constraint (VEL5APPO.BL1_CHARGE_PK) violated
=======

Cheers,
Kunwar

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2010

Added on Nov 10 2010

#general-database-discussions

3 comments

5,112 views