DROP TABLE roster_details;

CREATE TABLE roster_details(
	district	varchar2(10)		not null,
	rdate		varchar2(20)		not null,
	day		varchar2(10)		not null,
	station		number(3)		not null,
	watch		varchar2(2)		not null,
	duty_no		number(20)		not null,		
	CONSTRAINT con_duty_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;