Re: sqlload password not on command line?

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Wed, 23 Jun 1999 13:39:54 -0400
Message-ID: <37711BEA.63DD10D5_at_lucent.com>


Put this in a shell script:

#!/bin/ksh
sqlload control=myctl.ctl <<-sqlEOF
scott/tiger
sqlEOF

Rick Osterberg wrote:

> Is there any easy way to specify a user/password_at_database parameter for
> SQL*Loader (sqlload) that's _not_ on the command line? I want to run a
> SQL*Loader routine automatically, and don't want the username/password on
> the command line, because then it will show up in the 'ps' process
> listing. This is on Digital Unix/Compaq Tru64 Unix 4.0x, and Oracle 8.
> Thoughts?
>
> -Rick
>
> --
> +--------------------------------------------------------------------------+
> | Rick Osterberg osterber_at_fas.harvard.edu |
> +--------------------------------------------------------------------------+
Received on Wed Jun 23 1999 - 19:39:54 CEST

Original text of this message