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

Put your id/password in a file.
set protection so only you can see it.
pipe it into the loader or what not.

cat > my_pw
scott/tiger
^D
chmod 600 my_pw
sqlplus <my_pw _at_script_2_run

Simon Inglis (si002_at_seqeb.gov.au) wrote:

:> Greetings all,
:> I have a simple problem. I need to run some Oracle unix software as
:> part of a batch load of an Oracle datbase. To load the database I need to
:> run SQL*LOADER. 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"?
 

:> My only solution so far is to pipe my username/password to the oracle
:> tools. Eg for sqlplus:
 

:> -----start of shell script----------
:> echo "$MY_PASSWORD \
:> $1 $2 $3 $4 $5" | sqlplus -s
:> ------end of shell script-----------
 

:> Is there a more elegant solution?
:> _________________________________________________________________________
:> Simon Inglis
:> bss_simoni_at_seqeb.gov.au
:> singlis_at_gucis.cit.gu.edu.au
:> _________________________________________________________________________

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.