output with enable & disable of constraint and novalidate
if i am wrong on syntex please let me know


SQL> create table aa (code char(2) constraint pk_1 primary key,name char(20) )
2 ;

Table created.

SQL> insert into aa values ('11','anuj1') ;

1 row created.

SQL> commit ;

Commit complete.

SQL> insert into aa values ('11','anuj2') ;
insert into aa values ('11','anuj2')
*
ERROR at line 1:
ORA-00001: unique constraint (SCOTT.PK_1) violated


SQL> alter table aa disable constraint pk_1 ;

Table altered.

SQL> insert into aa values ('11','anuj2') ;

1 row created.

SQL> alter table aa enable constraint pk_1 novalidate ;
alter table aa enable constraint pk_1 novalidate
*
ERROR at line 1:
ORA-00933: SQL command not properly ended




[Edited by anujpathak on 04-15-2002 at 08:05 AM]