Re: SQL*Plus / Windows NT / host commands
From: Nathan Hughes <nhughes_at_cerberus.umd.umich.edu>
Date: 1997/07/13
Message-ID: <5q9jvr$9an_at_cerberus.umd.umich.edu>#1/1
Date: 1997/07/13
Message-ID: <5q9jvr$9an_at_cerberus.umd.umich.edu>#1/1
kgeis_at_ucsee.EECS.Berkeley.EDU (Ken Geis) writes:
> 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?
We ran into the same type of problem on our box - we solved by reversing the script logic, and running a batch file that called plus33, then our dos command (in this case sqlldr), rather than running a .sql file that hosts out. Works famously.
-- /(o\ Nathan D. Hughes \o)/ nhughes_at_umich.eduReceived on Sun Jul 13 1997 - 00:00:00 CEST