DROP TABLE assets;

CREATE TABLE assets(
	assetdate	varchar2(20)		not null,
	fault		varchar2(1000)		null,
	CONSTRAINT cons_assetdate PRIMARY KEY (assetdate) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;