Re: delete duplicated rows

I do not agree with you, Mr. Sybrand Bakker, there are several ways you can delete
duplicated rows.

The most common one is using rowid, however, if there are a lot of duplicated rows, you will need a huge rollback segs. If you have more than 10,000 rows to delete, it will take for ever.

You need to create a temp table, select dintinct from original table, use this temp table, write a PL/SQL to delete them.

Thanks  

-- 
Sent by dbadba62 from hotmail  in area  com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new