Re: SQL*Plus / Windows NT / host commands

Ken Geis (kgeis_at_ucsee.EECS.Berkeley.EDU) wrote:
:
: Hi. I'm running Oracle Workgroup Server 7.3 on NT 4.0 and using
: SQL*Plus 3.3. I have in a script to automate backups a line, 'host zip
: [zipfile] [datafile]'. This should compress the database file into the
: zipfile. So what happens is the zip command runs in the background, control
: returns to SQL*Plus, and the script takes the tablespace out of backup mode.
: So how do I get it to wait for the zip to complete?
: Thanks much,
:
: Ken Geis
: kgeis_at_ucsee.eecs.berkeley.edu
Ken,

[Quoted] Don't run the zip command in the background. If for whatever reason you need to run it in the background, then have [Quoted] the script wait until the zip process finishes. You can do this by checking processes or by creating temporary lock files.

-Ari Kaplan
[Quoted] Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 70+ technical tips, visit my Web Page:                    <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->