Re: HELP: How do I run batch programs with Oracle
Date: 1995/12/19
Message-ID: <DJuK73.FK4_at_txnews.amd.com>#1/1
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