Dear All, One table is having more than 5000 duplicate record. We would like to remove all the duplicate records. Using rowid method, it takes much time to execute. Is there any other way to remove all the duplicate rows in a faster manner. Regards, Balu This mail is scaned by eScan Anti Virus Software ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------