syntax to enable novalidate constraint

[clinton]

Can anybody tell me whats wrong with my syntax?

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

ERROR at line 4:
ORA-00905: missing keyword

syntax to enable novalidate constraint

[kris109]

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]