This does not work because the 'host' command to 'cd' creates a sub = shell in your environment. The cd will work in the sub shell, but when = that sub shell exits, the effect of 'cd' is lost and your cwd is the = directory of your parent shell. ----------------- Ron Reidy Lead DBA Array BioPharma, Inc. 303.386.1480 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Thiru Pandian Sent: Thursday, January 27, 2005 7:33 AM To: Oracle-L@xxxxxxxxxxxxx Subject: I want to change directory inside SQL script Hi,=20 I want to change the directory from sql script. I am applying few application patches which requires punch of sql needed to be run from different directory, i would like to automate this. @script1 change the directory=20 @script2 you may say that i should do @@ or specify the directory for parent script. But in the script they did not have @@. Is there any way do this? --=20 Thiru Pandian=20 Sr. Oracle DBA -- //www.freelists.org/webpage/oracle-l This electronic message transmission is a PRIVATE communication which = contains information which may be confidential or privileged. The information is = intended=20 to be for the use of the individual or entity named above. If you are = not the=20 intended recipient, please be aware that any disclosure, copying, = distribution=20 or use of the contents of this information is prohibited. Please notify = the sender of the delivery error by replying to this message, or notify us = by telephone (877-633-2436, ext. 0), and then delete it from your system. -- //www.freelists.org/webpage/oracle-l