Re: Duplicate records

If all the duplicate records were generated with one simple SQL statement. (for instance you have a batch job
and you accidentally ran it twice.) I've used the ROWID field to isolate the records and delete them. This can
only be done assuming all the duplicate records where created at the same time. Chances are they will fall
within a rowid range.

Hope this helps.

Greg V. vitetg_at_cam.org

Sushama Belkhode <sbelk_at_nctrf.nf.ca> wrote in article <33F43CB8.71BF_at_nctrf.nf.ca>...
> Can anyone tell me how to weed out duplicate records from a large(> 1
> million records) table quickly and efficiently?
>
> Thanks in advance
>
> Sushama
>
  Received on Fri Aug 22 1997 - 00:00:00 CDT