text:   CREATE TABLE "DEVELOPER"."EAR_AGGREGATE_CONTENTION" 
     (	"VET_ID" NUMBER(*,0), 
  	"CLAIM_ID" NUMBER(*,0), 
  	"DOB" NUMBER(4,0), 
  	"END_PRODUCT_CODE" VARCHAR2(12 BYTE), 
  	"RO_NUMBER" NUMBER(*,0), 
  	"CLAIM_DATE" DATE, 
  	"MAX_PROFILE_DATE" DATE, 
  	"CONTENTION_COUNT" NUMBER(3,0), 
  	"EAR_CONTENTION_COUNT" NUMBER(3,0), 
  	"C2200" NUMBER(3,0), 
  	"C2210" NUMBER(3,0), 
  	"C2220" NUMBER(3,0), 
  	"C3140" NUMBER(3,0), 
  	"C3150" NUMBER(3,0), 
  	"C4130" NUMBER(3,0), 
  	"C4210" NUMBER(3,0), 
  	"C4700" NUMBER(3,0), 
  	"C4920" NUMBER(3,0),
  	"C5000" NUMBER(3,0),
  	"C5010" NUMBER(3,0),
  	"C5710" NUMBER(3,0),	
  	"C6850" NUMBER(3,0),
  	"TXT_LOSS" NUMBER(3,0),
  	"TXT_TINITU" NUMBER(3,0)
     ) SEGMENT CREATION IMMEDIATE 
    PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP NOLOGGING
    STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "VBMS_TS" ;
   
  
    CREATE INDEX "DEVELOPER"."IX_AGGREGATE_CONTENTION_01" ON "DEVELOPER"."EAR_AGGREGATE_CONTENTION" ("VET_ID") 
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "INDEX_TS" ;
   
  