Re: Identify duplicate keys
From: Yves Noel <noel_at_citi.citilille.fr>
Date: 30 Mar 1993 07:30:07 GMT
Message-ID: <1p8stvINNdj_at_netserver.univ-lille1.fr>
Date: 30 Mar 1993 07:30:07 GMT
Message-ID: <1p8stvINNdj_at_netserver.univ-lille1.fr>
There was an excellent paper on this subject in the 'Bulletin Technique ORACLE'
France, number 5, write in Autumn 1989. The technique used to eliminate the
duplicate keys is based on the utilisation of the pseudo-column ROWID. A very
simple SQL script was given. If you don't find it I can send you this article. Bye !
In article <C4o9C6.8AC_at_da_vinci.it.uswc.uswest.com>, Jeffrey L. DeMent <jld_at_advtech.uswest.com> writes:
|> Trying to create an index on an Oracle V6 table -- but it's failing
|> because of duplicate keys. Is there a slick/fast/easy way to identify
|> the rows with duplicate keys (for subsequent deleting !) ?
|>
|> Thanks.
Received on Tue Mar 30 1993 - 09:30:07 CEST