Norman Dunbar wrote a comprehensive review of different methods which is
available at
http://www.jlcomp.demon.co.uk/faq/duplicates.html
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"ColoC" <colocoloc_at_yahoo.com> wrote in message
news:96fc2618.0309050529.708cf4be_at_posting.google.com...
> Hi, is there someone to help me?
>
> I have got a data duplication case in a big Oracle 8 table. Many of
> the records were processed and loaded twice, meanwhile there are much
> more good records without duplication. The table has 60 fields for
> each record.
>
> Is there a simple Oracle sqlplus way to capture all these duplications
> and remove the duplications?
>
> Thanks.
>
> ColoC
Received on Fri Sep 05 2003 - 10:16:00 CDT
