Re: HOST-command and NT

From: Andrew Hodgson <andrew_at_tcamiga.demon.co.uk>
Date: Mon, 27 Jul 1998 23:17:09 +0100
Message-ID: <GOxv8GAlxPv1EwFQ_at_tcamiga.demon.co.uk>


In article <35b5c0b7.0_at_news.uni-ulm.de>, Thomas Hesse <Thomas.Hesse_at_medizin.uni-ulm.de> writes
>I want to run a script in SQLPLUS like this:
>
>alter tablespace <table> begin backup;
>host copy <table.orig> <table.arch>
>alter tablespace <table> end backup;
>
>When I execute the HOST-command with SQLPLUS 3.1 NT open a
>cmd-window in which the HOST-command is running.
>The Problem is that SQLPLUS did not wait until the command
>has finished.
>What can I do ?
>
> Thomas
>
>---
>thomas.hesse_at_medizin.uni-ulm.de

Try two scripts, one to begin the backup, and one to copy the file, check for any errors, then end the backup. Call these from NT not sqlplus.

           |    Andrew Hodgson - Andrew_at_tcamiga.demon.co.uk   |
           |                     www.tcamiga.demon.co.uk      |
           |  Amiga 1200 030 33Mhz    |       6x86 P150+      |
           | 250Mb HD   HD Disk Drive | Quad Spd CD 5.3 Gb HD |
           | 6Mb Ram | CDTV | Motorola SurfR 56K |  80Mb Ram  |
                           Resistance is futile...
Received on Tue Jul 28 1998 - 00:17:09 CEST

Original text of this message