Re: Remove duplicates again

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 14 Mar 2001 00:13:31 +0100
Message-ID: <tata8sm1i5g240@beta-news.demon.nl>

"xiaomh" <xiaomh_at_hotmail.com> wrote in message news:98m3us$eh5$1_at_news.gov.on.ca...
> I want to import 100000 entries to my database. Each entry has mutiple
> columns, suppose 10 columns. There are some duplicates in them(sometimes
> according to (column1, column2), sometimes according to (column5,
column6)).
>
> How can I keep entries imported to database are unique on (column1,
column2)
> and (column5, column6).
>
> What's the best way to remove them(duplicates)?
>
> Thanks in advance!
>
>
>
>

As explained to you before the best option you have is to create appropiate primary and/or unique keys on the target table. Sqlloader will discard them and save them in the bad file, that is if you specify one.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Mar 13 2001 - 17:13:31 CST