DROP TABLE fire_chimney;

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

COMMIT;