Have u tried setting SQLPATH variable? Thanks, Arul. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thiru Pandian Sent: 27 January 2005 14:33 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 -- //www.freelists.org/webpage/oracle-l