Primary Key Creation

Create primary keys so they can be disabled without the corresponding index being dropped:

create table foobar (
col1 number constraint foobar_col1_pk
  primary key deferrable initially immediate
  -- using index tablespace indx
  ,
  col2 varchar2(5));