constraint syntax

[oracleman]

Can any one provide me with the syntax to Create a unique index novalidate

[kris109]

'novalidate' is a constraint state and you need create a constraint on the table and enable it in a novalidate state:

alter table junk
add constraint junk_user_id UNIQUE(user_id) enable novalidate;