DROP TABLE roster_manning;

CREATE TABLE roster_manning(
	duty_no		number(20)		not null,
	appl_1		varchar2(200)		not null,
	appl_2		varchar2(200)		not null,
	appl_3		varchar2(200)		null,
	appl_4		varchar2(200)		null,
	do		varchar2(100)		null,		
	CONSTRAINT con_manning_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;