You can find ( and delete) this rows with following queriy:
'Pos_sendungsnr' ist the unique - Key in this example:

-- Control:
select pos_sendungsnr from eu_faktura_header group by pos_sendungsnr having
count(*) > 1

-- Delete:
Delete from eu_faktura_header
group by pos_sendungsnr
having count(*) > 1

Good luck!
Vera

-----Ursprüngliche Nachricht-----
Von: VGaddipati
[mailto:oracledba-ezmlmshield-x12795000.[Email address protected]
Gesendet: Freitag, 29. Juli 2005 11:09
An: LazyDBA Discussion
Betreff: 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).


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to
these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page