Re: Sqlloader Appending with duplicated records

Ray

As far as I am aware, SQL*loader can't do updates. I guess you have 2 options really.

1. Write your loader process in PL/SQL using the UTL_FILE function to process the file. Here you could query the table before deciding to insert or update as appropriate.
2. Load your file into a temporary table of similar structure to the real one, in say, REPLACE mode. ie the table is wiped before loading occurs. Then have a bit of sql or pl/sql troll through the temporary table and applying inserts/updates as appropriate before finally clearing down the temp table.

Cheers

Clive

<vdragonz_at_my-deja.com> wrote in message news:8olsmt$kk8$1_at_nnrp1.deja.com...
> Hi all,
>
> I'm using SqlLoader to load my data into my database. I've to use the
> APPEND method because I've already got something in the database.
> However, in my new data, there are also some records that are updates
> of the old records in the database. Is there any method to do the
> append and the record updates at the same time? or do you have any
> good idea to solve this problem?
>
> Thank you very much !
>
> Ray
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Sep 02 2000 - 01:30:59 CEST