DROP TABLE fire_ia;

CREATE TABLE fire_ia(
	fire_number	number(20)		not null,
	first_officer	varchar2(20)		not null,
	senior_officer	varchar2(20)		null,
	gardai		varchar2(40)		null,
	esb	  	varchar2(40)		null,
	ambulance	varchar2(40)		null,
	local		varchar2(40)		null,
	other		varchar2(40)		null,
	chid		number(2)		null,
	CONSTRAINT con_fire_ia_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;