Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> De-duplication of large table

De-duplication of large table

From: Dave <none_at_nowhere.nothere.oops>
Date: Thu, 18 Nov 1999 20:04:15 -0000
Message-ID: <811m34$na5$1@lure.pipex.net> 





I have a 43,000,000 row table with about 225,000
duplicate records.


What is the easiest way to remove the duplicates.
I want to remove one of every duplicate record
from the table.



Dave



Received on Thu Nov 18 1999 - 14:04:15 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US