Re: SQL*Loader Question

From: Allan Lee <alee_at_netstakes.com>
Date: 1998/02/12
Message-ID: <6c0fr5$g68@bgtnsc03.worldnet.att.net>#1/1

Thanks Yuji for your reply.

I can't use the REPLACE option because it will clear or empty the whole table. I only need to update or make changes to the entry existing in the table.

I think my only option is to use UTL_File package. It is similar to what Ashraful suggested.

Thanks again.

allan

Yuji Shimono wrote in message <34E1EA94.41449A6B_at_foxinternet.net>...
>It seems to me that in the control file you can specify REPLACE to replace
>existing data in the table.
>
>Allan Lee wrote:
>
>> Hi,
>>
>> I'm able to insert new data using SQL*loader & it's fast especially using
>> the direct path load.
>>
>> Can SQL*Loader be used to update or change an existing entry in a table?
If
>> not, what's a fast way to update a record with data coming from a
>> comma-separated file. Is using UTL_FILE package a way to go? I'm afraid
>> using the package will be slow.
>>
>> Thanks in advance.
>>
>> allan
>
>
>
Received on Thu Feb 12 1998 - 00:00:00 CST