Re: How to call SQLLoader from a job?
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 21 Oct 2004 19:22:31 +0200
Message-ID: <4177ef7f$0$554$626a14ce_at_news.free.fr>
Date: Thu, 21 Oct 2004 19:22:31 +0200
Message-ID: <4177ef7f$0$554$626a14ce_at_news.free.fr>
"Robert Scheer" <rbscheer_at_my-deja.com> a écrit dans le message de
news:cfd22ab6.0410210735.210962be_at_posting.google.com...
> Hi.
>
> Once a day, I need to read data from a text file into a table in my
> Oracle database. I have been searching for examples on how to
> configure a job to run the SQLLoader utility, but could not find one.
> Can anyone point me to any kind of example about jobs and SQLLoader?
>
> Thanks,
>
> Robert Scheer
Use external table instead of SQL*Loader: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c11schem.htm#24433 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_73a.htm#2093662
-- Regards Michel CadotReceived on Thu Oct 21 2004 - 19:22:31 CEST