syntax to enable novalidate constraint

Quote:

Originally posted by clinton

SQL> alter table rugby add (constraint uk_rugby unique
........................................^ remove this (
(goalie,score) using index tablespace australian_rugby_indx
storage (initial 512M next 512M minextents 2 maxextents 100000
pctincrease 1 freelists 6 )) enable novalidate;
....................................^ remove this )

I tried a simple example and it works:

1 alter table junk
2* add constraint junk_uk UNIQUE (col1) enable novalidate
SQL> /

Table altered.

[Edited by kris109 on 03-04-2002 at 05:34 PM]