Unique Index Creation Failed: ORA-12801: error signaled in parallel query server P018, instance

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Error Description:
Oracle Unique Index creation failed with ORA-12801: error signaled in parallel query server P018.
CREATE UNIQUE INDEX
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P018,
instance bltexdb02.horizon.com.ar:TESTU42 (2)
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Solution Description:
The parallel query option stuck with an exceptional condition. You have to look for the subsequent error message. The subsequent error message will be different in each case. In the above case there are duplicate records found in the table and the unique index creation failed due to that. The duplicate records needs to be removed for successful execution of the UNIQUE index creation script. 

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer