Re: HELP: How do I run batch programs with Oracle
Date: 1995/12/15
Message-ID: <4asca1$84m_at_mojo.europe.dg.com>#1/1
In article <4apoml$8si_at_usenet.hydro.on.ca>, jerry.french_at_hydro.on.ca
says...
>
>si002_at_seqeb.gov.au (Simon Inglis) wrote:
......
>>My problem is this: How can I run SQL*LOADER from a
>>shell script (cshell) so that my username/password does not appear when
>>an user does a "ps -ef"?
>>Simon Inglis
....
>1. HERE FILE method
>
>***************************
>sqlplus -s <<!!
>`cat $password_file`
>sql_stuff
If you run sqlplus with a scriptfile you can put the username/password in
the FIRST line of the scriptfile and sqlplus will accept it. This way you
can invoke sqlplus with just the scriptfile name as the argument.
I have cron jobs that run daily using this method and it works fine.
I don't know if this method will work with SQL*LOADER but it's worth a
try.
Regards,
Michael.
Received on Fri Dec 15 1995 - 00:00:00 CET