Re: Sqlldr and cron

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
>SQL*Loader: Release 7.2.2.4.0 - Production on Fri Aug 29 16:18:03 1997
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>Message 901 not found; No message file for product=RDBMS,
>facility=ULMessage 210
>1 not found; No message file for product=RDBMS, facility=ULMessage 4008
>not foun
>d; No message file for product=RDBMS, facility=ULMessage 4009 not found;
>No mess
>age file for product=RDBMS, facility=ULMessage 4000 not found; No
>message file f
>or product=RDBMS, facility=ULMessage 4001 not found; No message file for
>product
>=RDBMS, facility=UL
>
>Thank you for your help Graemes

You have to remember that, when executing commands straight from cron, you have absolutely no environment set up (PATH, ORACLE_PATH, ORACLE_SID, etc).

Write a shell script that establishes the same kind of environment that you have when you log in interactively and then execute sqlldr. This should solve your problem.

Regards,
Dave Macpherson Received on Fri Aug 29 1997 - 00:00:00 CEST