Re: Delete doubles

From: Dante <dnotari_at_my-dejanews.com>
Date: Sat, 08 May 1999 09:46:44 GMT
Message-ID: <7h1164$4hq$1@nnrp1.deja.com>

Jerome,
you could create an unique constraint and have all violationg ROWIDs written into an exceptions table.

Then all you need to do is delete all rowids which are in the exceptionstable.

Regards
Dante
In article <7grg19$ev1$1_at_jaydee.iway.fr>, "Jérôme Texier" <jtexier_at_ystel.fr> wrote:
> Hello !
>
> I have load a table 2 times (there is no Unique key constraint). How can I
> delete my second load without delete my first load ?
>
> Please help me !
>
> ---------------
> Jérôme
> jt_at_ystel.fr
> ---------------
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat May 08 1999 - 04:46:44 CDT