Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ENABLE NOVALIDATE CONSTRAINT SYNTAX

704806Aug 26 2009 — edited Aug 3 2011
Hi,

I have a table it's called loadsurvey which having some duplicate records. I would like to implement unique constraint on my table using following command which should not allow any new duplicate record into table and do not wants to validate existing record.

ALTER TABLE LOADSURVEY ADD ENABLE NOVALIDATE
CONSTRAINT LOAD_UNIQUE_CONS UNIQUE (METERNO,DAT,TIM);

SQL COMMAND WINDOWS SHOWS "ORA-01735: INVALID ALTER TABLE OPTION"

Any help me to come out the problem.

Regards,
Saravanan.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2011
Added on Aug 26 2009
3 comments
1,107 views