The way I do it is to create another login.sql script for batch jobs only and place that in another directory. I have also created a file I call ".cronenv" under $HOME. This sets environment variables needed for cron jobs. In it, I set SQLPATH so the first place it looks is the directory I placed my new login.sql file.
SQLPATH=$HOME/cron_out:.:$HOME/dbacommon/tools/sqlscripts:$SQLPATH Then I put: . $HOME/.cronenv > /dev/null 2>&1 into all my batch jobs. This works for me. HTH, John -----Original Message----- Sent: Tuesday, March 25, 2003 9:29 AM To: Multiple recipients of list ORACLE-L Greetings Everyone! I have a LOGIN.SQL script that I've customized to fit my preferences. However, when I use SQLPLUS /NOLOG, it fails miserably since there is no connection to the database. Is there a way - other than undefining ORACLE_PATH - that the LOGIN.SQL script can be skipped or ignored when using the /NOLOG parameter? Thanks, Mike --- =========================================================================== Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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.net -- Author: John Carlson INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
