Deleting duplicate rows !!!

Deleting duplicate rows !!!

 

  

Hi folks,

we have a huge table with 3 million rows. After an import (disabling the
constraints on the table) we ended up having 4.5 million rows with lots of
duplicate rows.

Is there any way to delete these duplicate rows from the table ?




Kind Regards,
Venugopal R.
Technical Architect (Database).

Oracle LazyDBA home page