Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help: delete the duplecated records

Re: help: delete the duplecated records

From: sc <cfs3526_at_hotmail.com>
Date: Mon, 16 Oct 2000 10:16:50 -0400
Message-ID: <971705812.681231@newsreader-hpw1.net.bms.com>

That is what I did, it will take for ever to finish, if you have more than a few hundred records to delete.
Any other advice?

Thanks

"Valgaeren Dirk" wrote in message news:<8sf017$ef3$1_at_naxos.belnet.be>... > what if
you use this : > > delete from my_table t1 > where rowid > (select rowid from my_table t2
> where t2.my_field=t1.my_field); > >
Received on Mon Oct 16 2000 - 09:16:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US