Dear All,

Iam trying to remove the duplicate records from a table that has a total of around 32LAKH records with the query:

Delete from pdmcontact a where a.rowid > any (select rowid from pdmcontact b where a.hoclientid = b.hoclientid);

It has been running for more than around 3hours. Is there any other better way of deleting the duplicates or any idea as to how long should I wait or any clues to speed up the process??

Thanks in advance,

K.Diwakar