Re: SQL*Loader and userid/passwd

Subject: SQL*Loader and userid/passwd
From: Vern Kosloski, Vern.Kosloski_at_wilsons.mmbbs.com Date: 27 Mar 95 09:47:00
In article <1b2_9503271707_at_mmbbs.com> Vern Kosloski, Vern.Kosloski_at_wilsons.mmbbs.com writes:
>I am trying to run sqlldr without having the userid/passwd show up in a
 ps
>listing. I am runnging Oracle v7.0.16 on AIX 3.2.5. I know that I
 could put
>the userid/passwd in a parfile and it would not show up but I am trying
 to
>have only one place to set the userid/passwd. I was able to accomplish
 this
>task in Oracle v6 as follows:
>
>echo $ORACLEPW |sqllde $ORACLEUN parfile=param.prm
>
>This does not work in v7.0.16.
>
>I have an application that generates the parfile on the fly and sets the
>permissions to 700 and then deletes the file after the load but I was
>wondering if there was a way to do this similar the the v6 way.
>
>Thanks in advance.
>
>Vern Kosloski
>Vern.Kosloski_at_wilsons.mmbs.com

Try something like this:

sqlload parfile=param.pm <<EOF
$ORACLEUN/$ORACLEPW
EOF Bob Swisshelm | swisshelm_at_Lilly.com | 317 276 5472 Eli Lilly and Company | Lilly Corporate Center | Indianapolis, IN 46285 Received on Tue Mar 28 1995 - 13:34:11 CEST