DROP TABLE ems_location;

CREATE TABLE ems_location(
	ems_number	number(10)		not null,
	location	varchar2(50)		not null,
	complaint	varchar2(50)		not null,
	timeofcall	varchar2(10)		not null,
	mob		varchar2(10)		not null,
	ia		varchar2(10)		null,
	ls		varchar2(10)		null,
	ah		varchar2(10)		null,
	mav		varchar2(10)		null,
	cd		varchar2(10)		null,
	rt		varchar2(10)		null,	
	CONSTRAINT cons_ems_loc_number PRIMARY KEY (ems_number) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;