Re: Help on using host in sqlplus.

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.

Why do you call it a workaround?
That's how it is supposed to work.

Ed Received on Fri May 17 2002 - 06:47:58 CDT