DROP TABLE roadnames; CREATE TABLE roadnames( name varchar2(50) not null, area varchar2(50) not null, CONSTRAINT cons_name PRIMARY KEY (name) USING INDEX TABLESPACE INDX ) TABLESPACE USERS PCTFREE 10 PCTUSED 70 STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING; COMMIT;