Create a table with 'deferrable initially immediate'
SQL> create table inventory( 2 partno number(4) constraint partno_pk primary key deferrable initially immediate, 3 partdesc varchar2(35) constraint partdesc_uq unique deferrable initially immediate); Table created. SQL> SQL> SQL> SQL> drop table inventory; Table dropped.