Herds processed for JUN, 2002 as of: Jun 28, 2002
DECLARE
*
ERROR at line 1:
ORA-01502: index 'CMIP.HRD_DPC_FK_I' or partition of such index is in unusable state
ORA-06512: at line 84
ORA-06512: at line 224
Agcy Proc Date Tst-Proc Upl-Proc Tst-Mail Upl-Mail # Herds
------------- --------- ---------- ---------- ---------- ---------- ---------
04 28-JUN-02 3.4 .5 5.3 2.6 6582
05 28-JUN-02 2.8 .6 4.4 2.2 4254
10 28-JUN-02 2.6 .8 3.6 1.7 14
12 28-JUN-02 2.5 .7 3.6 1.8 665
13 28-JUN-02 7.7 2.4 9.3 4.1 19
14 28-JUN-02 3.3 .8 4.9 2.6 1505
6 rows selected.
Prov Proc Date Tst-Proc Upl-Proc # Herds
------------- --------- ---------- ---------- ---------
01 28-JUN-02 2.0 .7 184
02 28-JUN-02 2.3 .6 240
03 28-JUN-02 3.0 .7 242
04 28-JUN-02 3.4 .5 6583
05 28-JUN-02 2.8 .6 4266
06 28-JUN-02 3.3 .7 312
07 28-JUN-02 3.8 .7 196
08 28-JUN-02 3.4 .9 581
09 28-JUN-02 3.2 .7 419
10 28-JUN-02 2.8 1.0 16
10 rows selected.
Prov TRUNC(HTP Tst-Proc Upl-Proc Tst-Mail Upl-Mail # Herds
------------- --------- ---------- ---------- ---------- ---------- ---------
05 28-JUN-02 1.0 .6 2
05 28-JUN-02 2.0 .8 90
05 28-JUN-02 3.0 1.0 39
05 28-JUN-02 4.0 1.5 7
05 28-JUN-02 7.0 .7 7.0 1.0 1
06 28-JUN-02 2.0 .5 3
06 28-JUN-02 3.0 .9 8
06 28-JUN-02 4.0 2.3 1
07 28-JUN-02 2.0 .4 2
07 28-JUN-02 3.0 .7 5
07 28-JUN-02 4.0 .8 2
07 28-JUN-02 6.0 3.3 1
08 28-JUN-02 2.0 .9 6
08 28-JUN-02 3.0 1.1 7
08 28-JUN-02 4.0 1.3 1
08 28-JUN-02 5.0 1.8 1
09 28-JUN-02 2.0 .6 7
09 28-JUN-02 3.0 1.1 3
09 28-JUN-02 4.0 1.7 2
19 rows selected.
Agcy TRUNC(HTP Tst-Proc Upl-Proc Tst-Mail Upl-Mail # Herds
------------- --------- ---------- ---------- ---------- ---------- ---------
04 28-JUN-02 4.5 .8 7.1 1.8 206
05 28-JUN-02 2.4 .9 7.0 1.0 139
12 28-JUN-02 2.1 .7 24
14 28-JUN-02 2.9 1.0 49
4 rows selected.
Prov TRUNC(HTP Tst-Proc Upl-Proc Tst-Mail Upl-Mail # Herds
------------- --------- ---------- ---------- ---------- ---------- ---------
01 28-JUN-02 2.0 .7 6
02 28-JUN-02 2.1 .7 12
03 28-JUN-02 2.3 .8 6
04 28-JUN-02 4.5 .8 7.1 1.8 206
05 28-JUN-02 2.4 .9 7.0 1.0 139
06 28-JUN-02 2.8 .9 12
07 28-JUN-02 3.3 .9 10
08 28-JUN-02 2.8 1.1 15
09 28-JUN-02 2.6 .9 12
9 rows selected.