Re: Sqlldr and cron

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/08/29
Message-ID: <3406b245.16240258_at_www.sigov.si>#1/1

On Fri, 29 Aug 1997 16:31:30 +1200, Graeme Seymour <Graeme_seymour_at_bopelec.co.nz> wrote:

>Hi i need to use sqlldr to import some data into a oracle table on a
>unix box. I have set up the control files etc and can successfully
>import from the the command line and also use the at command and batch
>but have been unable to get cron to run this successfully. The message i
>get is
> ...[snip]...

You must set up your oracle environment in your cron script (ORACLE_SID, ORACLE_HOME, path, .....). Note that the cron will be most certanly executed unther Bourne shell (sh).

>Thank you for your help Graemes
>

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Aug 29 1997 - 00:00:00 CEST