DROP TABLE gender; CREATE TABLE gender( gid number(2) not null, gender varchar2(6) not null, CONSTRAINT con_gid PRIMARY KEY (gid) USING INDEX TABLESPACE INDX ) TABLESPACE USERS PCTFREE 10 PCTUSED 70 STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING; COMMIT;