HELP: How do I run batch programs with Oracle
From: Simon Inglis <si002_at_seqeb.gov.au>
Date: 1995/12/13
Message-ID: <DJIGoC.69s_at_un.seqeb.gov.au>#1/1
Simon Inglis
Date: 1995/12/13
Message-ID: <DJIGoC.69s_at_un.seqeb.gov.au>#1/1
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.auReceived on Wed Dec 13 1995 - 00:00:00 CET
_________________________________________________________________________