Duplicate rows

From: Computer Centre - NIIPL <compute_at_ponyneedles.com>
Date: Wed, 2 Jun 2004 15:26:58 +0530
Message-ID: <020901c44887$f1d528c0$63000050@newserver>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jun 02 2004 - 04:58:23 CDT