OraFAQ Forum: Server Utilities » Calling SQL*Loader utility with alias instead of password

Home » RDBMS Server » Server Utilities » Calling SQL*Loader utility with alias instead of password (Oracle dB 11 and above)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calling SQL*Loader utility with alias instead of password [message #485495]

Wed, 08 December 2010 10:15

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

Report message to a moderator

Re: Calling SQL*Loader utility with alias instead of password [message #485496 is a reply to message #485495]

Wed, 08 December 2010 10:18

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

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/

Report message to a moderator

Re: Calling SQL*Loader utility with alias instead of password [message #485502 is a reply to message #485496]

Wed, 08 December 2010 11:00

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

Report message to a moderator

Re: Calling SQL*Loader utility with alias instead of password [message #485511 is a reply to message #485502]

Wed, 08 December 2010 11:29

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What does you mean with "alias"? explain.

Regards
Michel

Report message to a moderator

Re: Calling SQL*Loader utility with alias instead of password [message #485514 is a reply to message #485511]

Wed, 08 December 2010 11:42

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.

Report message to a moderator

Re: Calling SQL*Loader utility with alias instead of password [message #485551 is a reply to message #485514]

Wed, 08 December 2010 14:23

Littlefoot
Messages: 21823
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>

Report message to a moderator

Previous Topic:	SQL*Loader-350 Syntax error when parsing data type
Next Topic:	problem with expdp-impdp huge space occupying

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 11:41:41 CST 2024