problem with ps command

Hi all

I use to run sql loader inside a script with usename and password written in syntax. Now when I use 'ps' command to know about the status of loading, it also shows username and password that I don't want to share with someone who is sitting with me. If you have any idea except encryption of password then please share.

Thanks in advance.

regards

I'm afraid that your problem isn't the ps command here :wink:

Generally speaking, unless you are comfortable sharing your username and password, they must never be supplied on the commandline.

In your case, I'd suggest you look for something like a .sqlloaderrc file. There's likely to be a client config file you can put the username and password in, then refer to that on the commandline.