After i sent the mail, i had to write a shell script to do that. I was wondering any other way to change inside sql. On Thu, 27 Jan 2005 20:27:28 +0530, Gracelin Priya S. <GracelinP@xxxxxxxxxxx> wrote: > Is ur oracle is in Windows or Unix?? > > If it is windows write a bat file that will call script1,then change the > directory and then the script2 > > If it is unix do it in a shell script.. > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Thiru Pandian > Sent: Thursday, January 27, 2005 8:03 PM > To: Oracle-L@xxxxxxxxxxxxx > Subject: I want to change directory inside SQL script > > Hi, > > 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 > @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? > > -- > Thiru Pandian > Sr. Oracle DBA > -- > //www.freelists.org/webpage/oracle-l > > -- Thiru Pandian Sr. Oracle DBA -- //www.freelists.org/webpage/oracle-l