DROP TABLE premises;

CREATE TABLE premises(
	fire_number	number(20)		not null,
	srtid		number(2)		null,
	tyid		number(2)		null,
	scrid		number(2)		null,
	oid		number(2)		null,
	did		number(2)		null,
	CONSTRAINT con_prem_fire_number PRIMARY KEY (fire_number) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;