Re: Sqlldr connect, unix batch

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Tue, 12 Jun 2007 10:28:25 -0000
Message-ID: <1181644105.587017.288450@q19g2000prn.googlegroups.com>

On Jun 12, 12:34 pm, g..._at_spray.se wrote:
> Howdy,
>
> Question on sql-loader...
>
> Is there a way for sqlldr to connect to the database from a unix batch-
> script
> without specifying the user/password on the command line,
> (avoiding the ps security-hole on a unix-server)?
>
> In sqlplus, you can put
> connect user/password
> in the beginning of a read-protected sql-script or in login.sql
>
> But how do you handle this with sql-loader?
>
> TIA,
> ----------------------------- grz01

Create a parameter file, put userid=user/password_at_alias into it and specify it using parfile keyword on sqlldr command line. You can put all other command line arguments into the parameter file as well.

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Tue Jun 12 2007 - 05:28:25 CDT