From oracle-l-bounce@freelists.org Thu Jan 27 10:16:37 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0RGFuj4011731 for ; Thu, 27 Jan 2005 10:15:57 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0RGFuem011723 for ; Thu, 27 Jan 2005 10:15:56 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BA06E6600E; Thu, 27 Jan 2005 10:15:07 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10018-01; Thu, 27 Jan 2005 10:15:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 380D565FE1; Thu, 27 Jan 2005 10:15:07 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=i+vAkci25lwjIQQtjHIN9MhouI+Q38McCbCDbMhIkrBEiPWz/UIw/PzuRzC6sSSV10IMrRDRgj83roy2dyd/9wWQJZBf82XV1PbK9sVGo6GawOl8RsMoRBXgvJVdDVyyRdvDDriEZG/jg8fuSo46dUEJ5bgl5rYskVORkU9SWxY= Message-ID: <1d23e2cc0501270713450148a6@mail.gmail.com> Date: Thu, 27 Jan 2005 10:13:26 -0500 From: Thiru Pandian To: "Gracelin Priya S." Subject: Re: I want to change directory inside SQL script Cc: Oracle-L@freelists.org In-Reply-To: <2BC68159E3EC814BA1E81C108DF99A42F209D5@EXCH-IND-VS1.india.quark.com> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <2BC68159E3EC814BA1E81C108DF99A42F209D5@EXCH-IND-VS1.india.quark.com> X-archive-position: 15319 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tpandian@gmail.com Precedence: normal Reply-To: tpandian@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: 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. 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@freelists.org > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Thiru Pandian > Sent: Thursday, January 27, 2005 8:03 PM > To: Oracle-L@freelists.org > 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 > -- > http://www.freelists.org/webpage/oracle-l > > -- Thiru Pandian Sr. Oracle DBA -- http://www.freelists.org/webpage/oracle-l