DROP TABLE inspection_3;

CREATE TABLE inspection_3(
	insdate		varchar2(40)		not null,
	warn		varchar2(10)		not null,
	sprinkler	varchar2(10)		not null,
	kit		varchar2(100)		not null,
	app		varchar2(10)		not null,
	cord		varchar2(10)		not null,
	liquid		varchar2(10)		not null,
	CONSTRAINT con_insdate PRIMARY KEY (insdate) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;