Re: LOADING TEXT FILE INTO TABLE (REPEATEDLY)
Date: Thu, 30 Apr 1998 19:35:20 -0400
Message-ID: <6ib1tb$in_at_bgtnsc03.worldnet.att.net>
SQL*Loader allows you to replace the existing table with your 'new' txt
file or APPEND to the end of the Table.
add APPEND or REPLACE into your ctl file, depending on what you want to
do (INSERT is default).
hopw this helps.
bobh
POWERS SMITH wrote:
>
> I will be getting a txt file from a PC that needs to be loaded into a
> Oracle table. This will occur several times a week, with the data in the
> txt file changing, but always going into the same Oracle table. Can I use
> sloader to repeatedly input into the same table, or do I have to write an
> embedded routine to do this? I would rather not use an embedded if I can
> use strickly Oracle tools.
>
> Any suggestions or help will be appreciated.
Received on Fri May 01 1998 - 01:35:20 CEST