Re: How to find Duplicate records

From: Norman Dunbar <ndunbar_at_lynxfinancialsystems.co.uk>
Date: Tue, 24 Jul 2001 07:57:42 +0100
Message-ID: <F43E6BAE5BB5D411A44C00805FBE740DD26DAE@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.

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 - 01:57:42 CDT