Dan, You said: "The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID, $SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus."
You are correct sir! However, you can generate the sql scripts within the NT script and use the environmental within that process. For example: Within an NT script, I say: echo spool $SCRIPT_LOG/some_script_file.log > run.sql echo select * from sysdate; >> run.sql echo exit >> run.sql sqlplus user/pw @run.sql The above would interpret the $SCRIPT_LOG environmental correctly. I do the above all the time and it works just fine. Hope this helps. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Tuesday, August 13, 2002 1:19 PM To: Multiple recipients of list ORACLE-L I've used MKS Toolkit and Cygwin for shell scripting. My preference is MKS Toolkit for features and it runs as the user you are logged in as (i.e. oracle). Cygwin is free, but it's processes run as the adminstrator. That being said, it could be I did not configure it properly.. The one 'gotcha' is that environment variables ($ORACLE_HOME, $ORACLE_SID, $SCRIPT_LOG, etc.) are not visible inside the Windows versions of SQL*Plus. Instead of using these variables, I used SQL*Plus native variables populated with a login.sql script. Not a problem. I'm not certain if the same restriction is present in perl, but it is something to keep in mind. Dan Fink -----Original Message----- Sent: Tuesday, August 13, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] 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: [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.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] 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: [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.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [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).
