DROP TABLE inspection_1;

CREATE TABLE inspection_1(
	building	varchar2(40)		not null,
	address		varchar2(100)		not null,
	dept		varchar2(40)		null,
	contact		varchar2(40)		null,
	director	varchar2(40)		null,
	idate		varchar2(40)		not null,
	rm		varchar2(40)		null,
	facman		varchar2(40)		null,
	CONSTRAINT con_idate PRIMARY KEY (idate) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;