DROP TABLE inspection_4;

CREATE TABLE inspection_4(
	inspdate	varchar2(40)		not null,
	dry		varchar2(10)		not null,
	trash		varchar2(100)		not null,
	prob		varchar2(100)		not null,
	action		varchar2(100)		not null,
	CONSTRAINT con_inspdate PRIMARY KEY (inspdate) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;