-- create index
CREATE INDEX ADMIN.AIX_POSTAL_ADDRESS_ALL
ON  ADMIN.POSTAL_ADDRESS(street_name,from_street_no,to_street_no,odd_even_both,city_id,province_id)  
TABLESPACE DBSTAR_IX PCTFREE 20 
   STORAGE ( INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED PCTINCREASE 30)
unrecoverable;

drop index ADMIN.AIX_vendor2;
CREATE unique INDEX ADMIN.AIX_vendor2
ON  ADMIN.vendor2(vendor_id)
TABLESPACE DBSTAR_IX PCTFREE 20 
   STORAGE ( INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED PCTINCREASE 30)
unrecoverable;

CREATE INDEX ADMIN.AIX_m128
ON  ADMIN.cnv_m128(requisition_number)  
TABLESPACE DBSTAR_IX PCTFREE 0 
   STORAGE ( INITIAL 100M NEXT 20M MAXEXTENTS UNLIMITED )
unrecoverable;

-- create unique index
CREATE unique INDEX ADMIN.uaix_payment
ON  ADMIN.payment(transaction_id)  
TABLESPACE DBSTAR_IX PCTFREE 20 
   STORAGE ( INITIAL 20M NEXT 10M MAXEXTENTS UNLIMITED PCTINCREASE 30)
unrecoverable;

CREATE unique INDEX ADMIN.uaix_cnv_table_type
ON  ADMIN.cnv_table_type(column_name)  
TABLESPACE DBSTAR_IX PCTFREE 20 
   STORAGE ( INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED PCTINCREASE 30)
unrecoverable;

-- create sequence
create sequence cwt_file_seq start with 1 nomaxvalue nocycle cache 20
;

-- create tablespace
-- NT
CREATE TABLESPACE DBSTAR 
   DATAFILE 'E:\ORADATA\DBSTAR\DBSTAR_DBSTAR.DBF' SIZE 20M autoextend on next 20M maxsize 1000M
DEFAULT STORAGE (INITIAL  2M NEXT  512K
                 MINEXTENTS 1 MAXEXTENTS 2147483645
                 PCTINCREASE 1)
ONLINE
;

-- unix
CREATE TABLESPACE DBSTAR 
   DATAFILE '/db03/oradata/DBSTAR/DBSTAR_DBSTAR' SIZE 500M autoextend on next 100M maxsize 1500M
DEFAULT STORAGE (INITIAL  2M NEXT  1M
                 MINEXTENTS 1 MAXEXTENTS 2147483645
                 PCTINCREASE 1)
ONLINE
;

CREATE TABLESPACE TESTITX
   DATAFILE '/db13/oradata/DBSTAR/DBSTAR_TESTITX' SIZE 200M autoextend on next 100M maxsize 6000M
DEFAULT STORAGE (INITIAL  1M NEXT  5M
                 MINEXTENTS 1 MAXEXTENTS 2147483645
                 PCTINCREASE 1)
;

-- create table
-- see c_table