Re: How to find Duplicate records

Hello!
Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:F43E6BAE5BB5D411A44C00805FBE740DD26DAE_at_apps.leeds.lfs.co.uk...
> The advice below will delete the duplicates ok, but it will also delete
> the rows you (probably) want to keep as well !
> When the exceptions table is used, Oracle doesn't know which of the
> duplicated rows you need/want to keep, so it puts them all into the
> exceptions table.

It's of course true.

Yaroslav.

>
> Be afraid, be very afraid :o)
>
> Norman.
>
> PS. Check out http://www.jlcomp.demon.co.uk/faq/duplicates.html for full
> details.
>
> ------------------------------------------------------------------------
> --------
> Norman Dunbar EMail: NDunbar_at_LynxFinancialSystems.co.uk
> Database/Unix administrator Phone: 0113 289 6265
> Lynx Financial Systems Ltd. Fax: 0113 201 7265
> URL: http://www.LynxFinancialSystems.com
> ------------------------------------------------------------------------
> --------
>
>
> -----Original Message-----
> From: Yaroslav Perventsev [mailto:p_yaroslav_at_cnt.ru]
> Posted At: Tuesday, July 24, 2001 6:55 AM
> Posted To: server
> Conversation: How to find Duplicate records
> Subject: Re: How to find Duplicate records
>
>
> <SNIP>
>
> After this manipulation you'll have table exception with rowids of
> duplpicate records and you may delete them:
>
> delete from YOUR_10_MILLION_TABLE
> where rowid in (select rowid from exception where
> table_name=YOUR_10_MILLION_TABLE)
>
>
Received on Tue Jul 24 2001 - 02:22:55 CDT