Re: Running multiple HOST commands via SQL*Plus

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

Hint: you can use .bat and .cmd files in your host command, and of course you can parametrize your .bat or .cmd file. This is not an Oracle issue

Hth

Sybrand Bakker
Senior Oracle DBA Received on Thu Feb 20 2003 - 09:42:45 CET