Duplicate Rows
Posted in 1997
I've got an old table with all columns allowing nulls (I wasn't here at the time!) with a unique index on it (how they got away with it all these years I'll never know). The index got corrupted, and rather than trying to tbcheck it, I thought it would be faster to drop it and re-create it (we're talking 12M rows here). Sure enough, it errors out with something like 'cannot insert row with duplicate values'. My question is: is there a quick way to isolate the duplicate rows (perhaps into a temp table) so that I can get rid of them? I'm using v5.02 on a RS6000 box. TIA, Herb ------------------------------------------------------------------------- Herb Blacker Cimarron, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------