Running multiple HOST commands via SQL*Plus

Hi all

First... Im running Oracle 8i (8.1.7.4.1) on Windows NT4 SP6a

Im trying to use the following command via SQL*Plus to backup a datafile and then gzip it:

HOST OCOPY E:\ORACLE\ORADATA\CRMUAT\CRM_INDEX_L01.DBF G:\ORACLE_BACKUP\CRMUAT\ && gzip -3Nvf
G:\ORACLE_BACKUP\CRMUAT\CRM_INDEX_L01.DBF When this is executed, OCOPY displays its usage info and doesn't do any work nor does the GZIP command run.

Does anyone have any ideas about this, has seen it before or can point me to some doco? Ive scoured Metalink & Google (and a few other websites) and the Oracle doco for NT but can't anything to help.

Thanks in advance

Alex Blyth Received on Thu Feb 20 2003 - 03:49:54 CET