DROP TABLE postalareas;

CREATE TABLE postalareas(
	area		varchar2(30)		not null,
	motor		varchar2(50)		not null,
	ambo		varchar2(50)		not null,
        et		varchar2(50)		not null,
	ladder		varchar2(50)		not null,
	hp		varchar2(50)		not null,
	decon		varchar2(50)		not null,
	wt		varchar2(50)		not null,
	ft		varchar2(50)		not null,
	district	varchar2(50)		not null,
	CONSTRAINT cons_area PRIMARY KEY (area) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;