Re: how to delete duplicate tuples???/

On Sun, 17 Dec 2006 13:46:59 -0800, DA Morgan <damorgan_at_psoug.org> wrote:

>Mladen Gogala wrote:
>> On Wed, 13 Dec 2006 09:31:41 -0800, lalit wrote:
>>
>>> hey guys ,,
>>> i m new to oracle and i m having a problem...
>>> how can i find out duplicate tuples and then delete them....
>>> plz reply.......
>>
>> One way would be to truncate the table. That will get 'em, nasty tuples.
>> That's something that Tom Kyte did not think about. For more practical
>> solution, enter "duplicate records" in the search engine on
>> http://asktom.oracle.com.
>> I dare say, though, that my solution will outperform Tom's.
>
>I'll bet DROP TABLE will too. <g>

the dupes would continue pissing you off from the recycle bin :) .......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Mon Dec 18 2006 - 10:28:23 CST