RE: Concealing SQL Loader password from ps -ef

From: Thomas, Kevin <Kevin.Thomas_at_calanais.com>
Date: Fri, 26 Oct 2001 00:54:25 -0700
Message-ID: <F001.003B55A5.20011026004020@fatcity.com>

Jay,

Could you tell me how to do this for SQL*PLUS, I'm too lazy to look now that I've found someone that knows ;o)

Cheers,
Kev.

"hit any user to continue"

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com

-----Original Message-----
Sent: 25 October 2001 17:56
To: Multiple recipients of list ORACLE-L

When running Sql Loader from a Unix script is there a way to code it so that the password will not be displayed when someone does ps -ef?

I know how to do it for sqlplus, exp and imp but not sql loader.

TIA,
Jay Miller
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Miller, Jay
INET: JayMiller_at_TDWaterhouse.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Thomas, Kevin
INET: Kevin.Thomas_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------