To make a long story short (too late!), I have an indexed archive table which is loaded via SQL*LOADER which I recently noticed has a disabled index because at some point in the past the same data file was inserted twice, creating about 7000 duplicate records. How would one write a PL/SQL script which would delete duplicate rows in a table?