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