Re: Duplicate rows in table with unique index

Biagio,
have a look at :
http://www.kbaseonline.com/
and look there for the tutorial named
"How can I figure out the duplicate rows in a table and delete them?"

http://www.kbaseonline.com/Topics/Articles/articles.asp?t=2&c=3:1

HTH,
ciao

Paolo

biagio.scognamiglio_at_convergere.com (Biagio) wrote in message news:<7762c0a8.0303110434.195a3d46_at_posting.google.com>...
> hi all,
>
> I found several duplicate rows in a table where a unique index exists
> and is valid. Could anybody suggest me how to recover the situation
> without invalidating the index and corrupting the table data?
>
> Someone could explain to me as this could happen?
>
> This happen on Oracle 8.1.7.0.0, Sun Sparc 32bit release.
>
>
> thanks,
> Biagio
Received on Wed Mar 12 2003 - 10:17:15 CET