[NT4] SQL*Plus HOST command doesn't wait for completion - BAD!

Gurus:

  I need help with executing a script in SQL*Plus (7.3...) under NT (4.0). Here is a piece of the script...

  ALTER TABLESPACE SYSTEM BEGIN BACKUP;
  HOST ocopy73 D:\ORANT\DATABASE\SYSTEM.DBF D:\orant\Backup   ALTER TABLESPACE SYSTEM END BACKUP; You can see that I'm trying to do a hot backup of the system tablespace. The problem is that the HOST command spawns a new shell to handle the copy, and returns control immediately to the next line! Is there a way to force the HOST command to wait for completion before returning? Any help would be appreciated!

Thanks in advance,
--Dave H.

PS. Oracle's solution was to insert a PAUSE after the HOST command and press a key when the copy was done. Great, but I want this to run at 3:00 am - unattended... Thanks, Oracle.

PPS. Ocopy73 is file copy program supplied by Oracle. I also tried copy and xcopy with the same results.

PPPS. Please reply here. If you can't, email me at music_at_waymark.net Received on Sat Apr 12 1997 - 00:00:00 CDT