: RE: Remove Duplicates
Tom.
Replies below.
Regards: Ferenc Mantfeld Senior Performance Engineer Siebel
Performance Engineering Melbourne, 3000,
VIC, Australia -Original
Message-From: Terrian, Tom
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, 4 June 2002 11:54
AMTo: Multiple
If your Duplicates are large in number then the
following method
works fine..
1.
create table TMP as select distinct ( set of columns
) from ORIGINAL_TABLE
2. truncate table ORIGINAL_TABLE
3. insert into ORIGINAL_TABLE select * from TMP/use
SQL Loader after taking a dump from TMP.
Bhulu
Here is an
interesting script I found on Metalink (Note:1019920.6) for removing duplicates, but I have not tried it yet:
== Title: == Script to Eliminate Non-unique Rows === Disclaimer: === This script is provided for educational purposes only. It is NOT
your second query will identify the rowids that are duplicates but will
not delete them. You'd have to then go through the exceptions table to
actually delete the rows.
however, the exceptions table is a good way to get an idea of how many
rows will be deleted. If you do have a large number of
Tom,
EXCEPTIONS, without the shadow of a doubt.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
Hi
Ferenc,
Welcome back !! We missed you
-
Kirti
-Original Message-From: Ferenc Mantfeld
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 04, 2002 3:49
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Remove Duplicates
Tom.
Replies below.
Regards: Ferenc
Ferenc,
I agree with your improvement on the first query but I disagree about
your opinion about the EXCEPTIONS method. Especially if there are not
too many (in proportion) duplicates you can remove them as follows :
create table my_table_dup
as select distinct *
from
Now that's a blast from the past. What's it been, two or three years since
we have seen Ferenc make an appearance?
Regards,
Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781
-Original Message-
Kirti
Sent: Tuesday, June 04, 2002 4:22 PM
To: Multiple recipients of list ORACLE-L
Hi Ferenc,