DROP TABLE ignition_source; CREATE TABLE ignition_source( srcid number(2) not null, source varchar2(30) not null, CONSTRAINT con_srcid PRIMARY KEY (srcid) USING INDEX TABLESPACE INDX ) TABLESPACE USERS PCTFREE 10 PCTUSED 70 STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING; COMMIT;