DROP TABLE specials;

CREATE TABLE specials(
	fire_number	number(10)		not null,
	said 		number(2)		null,
	exid		number(2)		null,
	fbid		number(2)		null,
	spid		number(2)		null,
	ssid		number(2)		null,
	locid		number(2)		null,
	mid		number(2)		null,
	wid		number(2)		null,
	iid		number(2)		null,
	CONSTRAINT cons_spec_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;