Re: Username Prompt in SQLLoader

Thomas Pennington (tompenn_at_info.census.gov) wrote:
: Has anyone determined how to get rid of or bypass the
: annoying username prompt from Sqlplus, export, import,
: or sqlloader??. The accounts which execute these are
: defined as OS authentication in the database so that
: we do not have to put the username/password in the
: command files, but the processes HAVE to run in a
: "batch" or unattended mode: ie, cron starts a job to
: load a new file into the database at 4:00 am, and it
: stalls then dies at the USERNAME prompt. Also, if the
: database authentication is at the OS level, why does
: the prompt even come up??. Any help would be GREATLY
: appreciated. Thanks,

Have your tried to call the utility (sqlplus,imp..) like this

  sqlplus /

Without name and password. Sqlplus should then use this OPS$ OS authentication for logon.

Regards

Ari Likki
Yhtyneet Kuvalehdet Oy/United Magazines Ltd Helsinki, Finland Received on Thu Sep 29 1994 - 00:24:02 CET