Help on using host in sqlplus.

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 Thu May 16 2002 - 08:34:46 CDT