DROP TABLE inspection_2;

CREATE TABLE inspection_2(
	indate		varchar2(40)		not null,
	obs		varchar2(10)		not null,
	exit		varchar2(10)		not null,
	bulb		varchar2(10)		not null,
	hall		varchar2(10)		not null,
	escape		varchar2(10)		not null,
	locked		varchar2(10)		not null,
	plan		varchar2(10)		not null,
	smoke		varchar2(10)		not null,
	place		varchar2(10)		not null,
	CONSTRAINT con_indate PRIMARY KEY (indate) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;