Duplicate rows

  • From: "Computer Centre - NIIPL" <compute@xxxxxxxxxxxxxxx>
  • To: "ORALCE LIST" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 2 Jun 2004 15:26:58 +0530

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
-----------------------------------------------------------------

Other related posts: