Tablespace   STA M A Init     Total MB    Free MB     Used MB  LrgstMB       MaxExt %Fr A
------------ --- - - ---- ------------ ---------- ----------- -------- ------------ --- -
AMINDEX     OLN L S  64K        5,120      5,120           0    3,968   2147483645 100
AMOWNER     OLN L S  64K        5,120      5,120           0    3,968   2147483645 100
BOB_TS       OLN L U  10M       17,240     16,130       1,110    9,740   2147483645  94
DDP_TAB      OLN L U   1M        5,120      3,700       1,420    3,507   2147483645  72
GGS_HOLD     OLN L S  64K       27,000     22,201       4,799    3,968   2147483645  82
GGS_IDX      OLN L U   1M      714,880    274,099     440,781   20,803   2147483645  38
GGS_TAB      OLN L U   1M      473,119    104,097     369,022   28,455   2147483645  22
SYSAUX       OLN L S  64K        5,598      2,597       3,001      462   2147483645  46
SYSTEM       OLN L S  64K       12,848     11,802       1,046    3,903   2147483645  92
TEMP         OLN L U   1M       32,767     32,722          45   32,766              100
UNDOTBS1     OLN L S  64K       80,291     17,307      62,985    3,968   2147483645  22
USERS        OLN L S  64K        5,917      1,152       4,765      944   2147483645  19 *

INSERT /*+ APPEND */ INTO DBA.BOB_CUSTOMER_RATE (
   ACCTCORP, HOUSE, CUST,
   SERV, CATEGORY, RCTR01,
   RCTR02, RCTR03, RCTR04,
   RCTR05, RCTR06, RCTR07,
   RCTR08, RCTR09, RCTR10,
   RCTR11, RCTR12, RCTR13,
   RCTR14, RCTR15, RCTR16,
   RCTR17, RCTR18, RCTR19,
   RCTR20, SOURCE_UPDATE_DATE, RPTCTR_CONCAT,
   PROMO_FLAG, KILL_FLAG,LNAME,FNAME,RPHON,
   STAT,RAREACD,CUSTPIN,ANNIVDAY)
SELECT B.ACCTCORP, B.HOUSE, B.CUST,
       F.SERV, A.CATEGORY,D.RCTR01,
       D.RCTR02, D.RCTR03,
       D.RCTR04, D.RCTR06,
       D.RCTR05, D.RCTR07,
       D.RCTR08, D.RCTR09,
       D.RCTR10, D.RCTR11,
       D.RCTR12, D.RCTR13,
       D.RCTR14, D.RCTR15,
       D.RCTR16, D.RCTR17,
       D.RCTR19, D.RCTR18,
       D.RCTR20,B.SOURCE_UPDATE_DATE,' ',
       CASE
          WHEN (e.rprmonth>0) THEN 'PROMO'
          WHEN (e.addressable=4 and e.deliverysysid=' ') then 'FEAT'
          ELSE 'PASS'
          END AS PROMO_FLAG,' ',
       LNAME,FNAME,RPHON,STAT,RAREACD,CUSTPIN,ANNIVDAY
  FROM DBA.BOB_CAT_CODES A,
       DBA.BOB_CUST B,
       (select distinct acctcorp,house from DBA.BOB_HOUSE_SERVICE_AVLBLTY
         where svc_avl_type=99) C,
       GGS.IDST_RATE_REPORTING_CENTER D,
       GGS.IDST_RATE_CODE E,
       (SELECT P.ACCTCORP,P.HOUSE,P.CUST,P.SERV FROM DBA.BOB_CUST_RATE P
       UNION ALL
       SELECT Q.ACCTCORP,Q.HOUSE,Q.CUST,Q.NEWCODE AS "SERV" FROM DBA.BOB_CUST_PROMO Q) F,
       DBA.BOB_STATUS X
 WHERE      (D.ACCTCORP = E.ACCTCORP)
        AND (D.DRATECODE = E.RCODE)
        AND (E.ACCTCORP = F.ACCTCORP)
        AND (E.RCODE = F.SERV)
        AND (A.ACCTCORP = D.ACCTCORP)
        AND ((A.RPT_CTR = D.RCTR01)
        OR (A.RPT_CTR = D.RCTR02)
        OR (A.RPT_CTR = D.RCTR03)
        OR (A.RPT_CTR = D.RCTR04)
        OR (A.RPT_CTR = D.RCTR05)
        OR (A.RPT_CTR = D.RCTR06)
        OR (A.RPT_CTR = D.RCTR07)
        OR (A.RPT_CTR = D.RCTR08)
        OR (A.RPT_CTR = D.RCTR09)
        OR (A.RPT_CTR = D.RCTR10)
        OR (A.RPT_CTR = D.RCTR11)
        OR (A.RPT_CTR = D.RCTR12)
        OR (A.RPT_CTR = D.RCTR13)
        OR (A.RPT_CTR = D.RCTR14)
        OR (A.RPT_CTR = D.RCTR15)
        OR (A.RPT_CTR = D.RCTR16)
        OR (A.RPT_CTR = D.RCTR17)
        OR (A.RPT_CTR = D.RCTR18)
        OR (A.RPT_CTR = D.RCTR19)
        OR (A.RPT_CTR = D.RCTR20))
        AND (B.ACCTCORP = C.ACCTCORP(+))
        AND (B.HOUSE = C.HOUSE(+))
        AND (F.ACCTCORP = B.ACCTCORP)
        AND (F.HOUSE = B.HOUSE)
        AND (F.CUST = B.CUST)
        AND (B.ACCTCORP=X.ACCTCORP)
  AND 1 = X.STATUS
  AND 'DIV_EASTERN_3' = x.notes
  AND c.house is null

BOB_TS       OLN L U  10M       17,240     16,130       1,110    9,740   2147483645  94
USERS        OLN L S  64K        5,917      1,152       4,765      944   2147483645  19 *
TEMP         OLN L U   1M       32,767     32,722          45   32,766              100