Re: Spool To More than 1 File

You got the answer?

Here is what I going to do

Spool /tmp/hardcoded_file.txt #you can't use variable here select sysdate from dual;
spool off
host /usr/bin/cp /tmp/hardcoded_file.txt /tmp/hardcoded_file2.txt

• Original Message ----- From: "Post, Ethan" <Ethan.Post_at_ps.net> To: <oracle-l_at_freelists.org> Sent: Tuesday, June 07, 2005 12:46 AM Subject: Spool To More than 1 File

> One thing I would like to see is the ability to spool output from
> SQL*Plus to more than one file at a time. I am writing a script in which
> I am spooling the results of each command to "foo" and then grepping the
> foo file for the elapsed time and putting it in a log file using "!grep
> ...". The problem with this method is that I can't spool the results of
> the entire script to another file in the event I want to see the detail.
> I could use some "cat" commands to keep moving the results but this
> seems like a pretty easy and perhaps usefull feature.
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l