set constraint deferred

SQL> create table t ( n number );

Table created.

SQL> create index i on t ( n );

Index created.

SQL> alter table t add constraint p primary key ( n ) deferrable;

Table altered.

SQL> insert into t ( n ) values ( 0 );

1 row created.

SQL> commit;

Commit complete.

SQL> insert into t ( n ) values ( 0 );
insert into t ( n ) values ( 0 )
*
ERROR at line 1:
ORA-00001: unique constraint (U.P) violated


SQL> set constraint p deferred;

Constraint set.

SQL> insert into t ( n ) values ( 0 );

1 row created.

SQL> commit;
commit
*
ERROR at line 1:
ORA-02091: transaction rolled back
ORA-00001: unique constraint (U.P) violated