Re: HELP: How do I run batch programs with Oracle

Michael_Kelly_at_dge.ceo.dg.com (Michael Kelly) wrote:
>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.
>

To have the user id validated at the OS Level is a good option.

Thereafter you can invoke sqlplus or sqlload without specifying any userid/passwd.

sqlplus /
sqlload /
Regards,
Suman. Received on Tue Dec 19 1995 - 00:00:00 CET