DROP TABLE fire_incident;

CREATE TABLE fire_incident(
	fire_number	number(20)		not null,
	fire_date	varchar2(30)		not null,
	caller_det	varchar2(40)		null,
	owner_det	varchar2(40)		null,
	incident_det	varchar2(100)		not null,
	contact_name	varchar2(40)		null,
	sid		number(2)		not null,
	ftid		number(2)		null,
	stid		number(2)		null,
	fid		number(2)		null,
	CONSTRAINT con_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;