Subject: Re: SQL*Plus / Windows NT / host commands
Newsgroups: comp.databases.oracle.tools
References: <5p9k8o$2gq@agate.berkeley.edu>
Reply-To: akaplan@interaccess.com
Distribution:
Ken Geis (kgeis@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@ucsee.eecs.berkeley.edu
Ken,
Don't run the zip command in the background. If for whatever reason you need to
run it in the background, then have the script wait until the zip process
finishes. You can do this by checking processes or by creating temporary lock
files.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 70+ technical tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page