DROP TABLE hydrant;

CREATE TABLE hydrant (
	no		NUMBER(10)		NOT NULL,
	location	VARCHAR2(100)		NOT NULL,
	fault		VARCHAR2(100)		NULL,
	pressure	VARCHAR2(100)		NOT NULL,
	type		VARCHAR2(100)		NOT NULL,
	condition	VARCHAR2(100)		NOT NULL,
	CONSTRAINT con_no PRIMARY KEY (no) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;