Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help: delete the duplecated records
maybe you can do this :
create a table without duplicates
delete the table with the duplicates
create a table with the original name without duplicates
drop the first table.
On the other hand I doubt it'll go any faster.
sc <cfs3526_at_hotmail.com> schreef in berichtnieuws
971705812.681231_at_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 Tue Oct 17 2000 - 01:51:34 CDT