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

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. 
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google