Re: Help on using host in sqlplus.

Try putting your HOST command on one line

alter tablespace SYSTEM begin backup;
host(/usr/bin/tar cvf - /ud2/ORACLE2/ORTEST1/DATA/SYS1ORTEST1.DBF \ |compress>/tape1/SYSTEM_25_may_99.Z )
exit
alter tablespace SYSTEM end backup;

M

shrekreturn_at_yahoo.com (Matt) wrote in message news:<955c3e6.0205160534.48fae2c3_at_posting.google.com>...
> Hi, there,
>
> I was testing a script similar as this one:
>
> alter tablespace SYSTEM begin backup;
> host
> /usr/bin/tar cvf - /ud2/ORACLE2/ORTEST1/DATA/SYS1ORTEST1.DBF \
> |compress>/tape1/SYSTEM_25_may_99.Z
> exit
> alter tablespace SYSTEM end backup;
>
> If I copy paste this to sqlplus, it runs perfectly. However, if I save
> this script into a file, say test.sql, and run it (@test.sql) in
> sqlplus, it will pause after the host and waite for my input. It does
> not run the tar command. I can work around this by put host and tar
> etc into one line. But that is not what I intend to do. What I did
> wrong here? Any help is appreciated.
>
> I use 8.1.7.3 on solaris 8 sparc.
>
> Thanks.
Received on Fri May 17 2002 - 03:01:31 CDT