DROP TABLE roster_extras;

CREATE TABLE roster_extras(
	duty_no		number(20)		not null,
	training	varchar2(40)		null,
	overtime	varchar2(40)		null,
	transfers	varchar2(40)		null,
	oic		varchar2(40)		null,	
	CONSTRAINT con_extras_no PRIMARY KEY (duty_no) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;