Re: Running multiple HOST commands via SQL*Plus

Its probably best to encapsulate all your commands into a batch file and run the batch file via the host command. Spaces and carriage returns in your current statement may be causingit to fail.

Also, one OS command per host call.

M

alex_blyth_at_amp.com.au (Alex Blyth) wrote in message news:<7ae9eb69.0302191849.134b7941_at_posting.google.com>...
> 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 - 10:27:03 CET