Please help w/ SQL COPY command

Please help -
  I am in the process of a large migration. I am using the sqlplus copy command to copy a very large table (made up of numbers, dates, and varchar2's)
  The copy command gives a summary :
Array fetch/bind size is 1000. (arraysize is 1000) Will commit after every array bind. (copycommit is 1) Maximum long size is 80. (long is 80)

   13941394 rows selected from OPS$OCFDBA_at_MIRROR.    13941394 rows inserted into OPS$OCFDBA.EVENT.    13941394 rows committed into OPS$OCFDBA.EVENT at DEFAULT HOST connection.

Count (*) on the 'mirror' yields 13941394 ROWS.

Count (*) on the 'host' yields 7350394 ROWS !!!!!

After the copy, I built 8 large indexes(with no errors), then did an 'analyze ESTIMATE statistics.'

All the other tables match. Where is the confusion, and how can I verify all the data made it accross???

(On a side note, I did build the indexes parallel, unrecoverable)

Host - Oracle 7.3.2.3.2 on OpenVms 7.1 Mirror - Oracle 7.1.3.2.0 on VMS 6.2

Thanks
Doug

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 02 1998 - 14:44:32 CST