de-dup process

  • From: A Ebadi <ebadi01@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 12 Dec 2006 14:31:17 -0800 (PST)

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.

Other related posts: