Home » RDBMS Server » Server Utilities » Calling SQL*Loader utility with alias instead of password (Oracle dB 11 and above)
Calling SQL*Loader utility with alias instead of password [message #485495] Wed, 08 December 2010 10:15 Go to next message
zlazarevgmailcom
Messages: 2
Registered: December 2010
Junior Member
Hi,

Can I use the alias instead of password when calling to ORACLE sqlldr utility to load data files?

Thanks.
Zeev
Re: Calling SQL*Loader utility with alias instead of password [message #485496 is a reply to message #485495] Wed, 08 December 2010 10:18 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can I use Zeev instead of Regards when I answer?

Regards
Michel

[Updated on: Wed, 08 December 2010 10:19]

Report message to a moderator

Re: Calling SQL*Loader utility with alias instead of password [message #485497 is a reply to message #485496] Wed, 08 December 2010 10:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can I use the alias instead of password when calling to ORACLE sqlldr utility to load data files?
You can use what ever works for you.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Calling SQL*Loader utility with alias instead of password [message #485502 is a reply to message #485496] Wed, 08 December 2010 11:00 Go to previous messageGo to next message
zlazarevgmailcom
Messages: 2
Registered: December 2010
Junior Member
Hi Michel,

Thanks for your reply.
First, the reason I ask is a security concern when the plain text password in SQL*Loader invocation can be the hole for malicious intruders.
As I know the SQL*Plus does support the alias instead of clear text password and this gives you the basic level of protection.
The Oracle documentation - OracleUtilities.pdf file - doesn't address this issue, nor I found it on the Internet.

I'll appreciate if someone will refer me to additional info for the answer to this question.

Thanks.
Zeev
Re: Calling SQL*Loader utility with alias instead of password [message #485511 is a reply to message #485502] Wed, 08 December 2010 11:29 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does you mean with "alias"? explain.

Regards
Michel
Re: Calling SQL*Loader utility with alias instead of password [message #485514 is a reply to message #485511] Wed, 08 December 2010 11:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I'll appreciate if someone will refer me to additional info for the answer to this question.
what exactly is the question?

Solution may depend upon Operating System name & version.
Solution may depend upon whether sqlldr is being invoked on DB Server or remote client.
Re: Calling SQL*Loader utility with alias instead of password [message #485551 is a reply to message #485514] Wed, 08 December 2010 14:23 Go to previous message
Littlefoot
Messages: 21687
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Although more information (from your side) might make things clear, here's one option: simply don't specify a password if you are invoking SQL*Loader interactively (note the second line - "Password" waits for your input, hides what you type and - if everything is OK - loads data):
C:\TEMP>sqlldr userid=scott control=test.ctl log=test.log
Password:

SQL*Loader: Release 10.2.0.1.0 - Production on Sri Pro 8 21:19:56 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Commit point reached - logical record count 2
Commit point reached - logical record count 3

C:\TEMP>
Previous Topic: SQL*Loader-350 Syntax error when parsing data type
Next Topic: problem with expdp-impdp huge space occupying
Goto Forum:
  


Current Time: Fri Sep 17 08:27:32 CDT 2021