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@xxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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

Other related posts: