sqlldr userid/pass control=test.ctl log=test.log bad=test.bad discard=test.dsc

userid=userid/pass
control=test.ctl
log=test.log
bad=test.bad
discard=test.dsc

sqlldr parfile=test.par

userid=shadow_max85

chmod 600 ~/text/privatestuff

. ~/text/privatestuff
sqlldr $userid/pass control=test.ctl log=test.log bad=test.bad discard=test.dsc

Quote:

Originally Posted by KenJackson You want to hide the userid, but not the password? That's the reverse of what is normally wanted, but OK. I assume this a shell script.

Thank so much.
But I thinks u misunderstand me. I need to hide user id and also the password.

Quote:

Originally Posted by KenJackson You can create a text file, say ~/text/privatestuff with contents like this: Code: userid=shadow_max85 Set it so only you can read it: Code: chmod 600 ~/text/privatestuff

With above condition(hiding userid/password). Can i put both user id and password in one text file.
~/text/privatestuff

Code:

userid=shadow_max85/pass

Quote:

Originally Posted by KenJackson Then in your main script file, use it like this: Code: . ~/text/privatestuff sqlldr $userid/pass control=test.ctl log=test.log bad=test.bad discard=test.dsc The first line is: period, space, filepath. It causes the contents of the file to be executed in the current process. It doesn't even need to be an executable file.

. ~/text/privatestuff
sqlldr $userid control=test.ctl log=test.log bad=test.bad discard=test.dsc

connect shadow_max85/pass

sqlplus /nolog <<EOF
@/home/logon.sql