Herds processed for JUN, 2002 as of: Jun 30, 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 30-JUN-02 3.4 .5 5.3 2.6 6575
05 30-JUN-02 2.8 .6 4.4 2.2 4252
10 30-JUN-02 2.5 .5 3.4 1.5 14
12 30-JUN-02 2.5 .7 3.6 1.8 664
13 30-JUN-02 7.6 2.4 9.4 4.1 19
14 30-JUN-02 3.3 .8 4.9 2.6 1506
6 rows selected.
Prov Proc Date Tst-Proc Upl-Proc # Herds
------------- --------- ---------- ---------- ---------
01 30-JUN-02 2.0 .7 183
02 30-JUN-02 2.3 .7 240
03 30-JUN-02 3.0 .7 242
04 30-JUN-02 3.4 .5 6576
05 30-JUN-02 2.8 .7 4264
06 30-JUN-02 3.3 .7 313
07 30-JUN-02 3.8 .7 196
08 30-JUN-02 3.4 .9 581
09 30-JUN-02 3.1 .7 419
10 30-JUN-02 2.7 .7 16
10 rows selected.
Prov TRUNC(HTP Tst-Proc Upl-Proc Tst-Mail Upl-Mail # Herds
------------- --------- ---------- ---------- ---------- ---------- ---------
09 30-JUN-02 2.0 .1 1
09 30-JUN-02 4.0 .0 1
2 rows selected.
Agcy TRUNC(HTP Tst-Proc Upl-Proc Tst-Mail Upl-Mail # Herds
------------- --------- ---------- ---------- ---------- ---------- ---------
04 30-JUN-02 3.1 .1 86
14 30-JUN-02 3.0 .1 2
2 rows selected.
Prov TRUNC(HTP Tst-Proc Upl-Proc Tst-Mail Upl-Mail # Herds
------------- --------- ---------- ---------- ---------- ---------- ---------
04 30-JUN-02 3.1 .1 86
09 30-JUN-02 3.0 .1 2
2 rows selected.