Re: LOADING TEXT FILE INTO TABLE (REPEATEDLY)

You can use sqlloader to do it.But use REPLACE option instead of APPEND. Define your keys carefully. If you need any other clarification, you can reach me at

ubsram_at_pacific.net.sg

See ya.

POWERS SMITH <pasmith_at_ppg.com> wrote in article <01bd7482$3df55260$aab0bd8d_at_ppg.com>...
> 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 - 18:22:50 CEST