RE: de-dup process
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <ebadi01@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 12 Dec 2006 17:53:07 -0500
Lots of solutions. Try a search on AskTom (http://asktom.oracle.com/)
or MetaLink specifying "delete duplicate rows".
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
There is nothing so useless as doing efficiently that which shouldn't be
done at all. -Peter F. Drucker, 1909-2005
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of A Ebadi
Sent: Tuesday, December 12, 2006 5:31 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: de-dup process
We have a huge table (> 160 million rows) which has about 20 million
duplicate rows that we need to delete. What is the most efficient way
to do this as we will need to do this daily?
A single varchar2(30) column is used to identified duplicates. We could
possibly have > 2 rows of duplicates.
We are doing direct path load so no unique key indexes can be put on the
table to take care of the duplicates.
Platform: Oracle 10G RAC (2 node) on Solaris 10.
Thanks!
________________________________
Need a quick answer? Get one in minutes from people who know. Ask your
question on Yahoo! Answers
<http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMz
OTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx> .
Other related posts:
