Oracle Database Discussions

TO use the feature of EXCEPTION into when creating unique index, I run the folllwing command to enable a unique constraints:

alter table TEST_DUP2 enable constraint UNQ_TEST_DUP2
using index tablespace EDWSALESINDEX nologging
EXCEPTIONS into exceptions

This will create the unique index and when duplicate uniqe key encountered, the command fails and store the rowid of the duplicating row to exceptions table.

Now I want to run this commnad in parallel to enhance performance. I tried
alter table TEST_DUP2 enable constraint UNQ_TEST_DUP2
using index tablespace EDWSALESINDEX nologging PARALLEL
EXCEPTIONS into exceptions

and I got SQL Error: ORA-00933: SQL command not properly ended.

Can this be done, or are there any worka around ?

I do not want create unique index explicitly as that does not have the EXCEPTION into feature.

Thanks