RE: Spool To More than 1 File

Thanks, I am aware of a number of ways I could do this but thinking it was rather short sited of Oracle to not add this into SQL*Plus directly, this must be really easy to do. I would like to be able to do all this completely within SQL*Plus.

-----Original Message-----
From: Eric Buddelmeijer [mailto:Eric.Buddelmeijer_at_elegant.nl]=20 Sent: Monday, June 06, 2005 2:29 PM
To: Post, Ethan; oracle-l_at_freelists.org
Subject: RE: Spool To More than 1 File

If you are using some sort of *nix, I just succeeded in getting two files on
cygwin using tee:

cat <file_name> |tee out 1>out2

tee writes to the standard output (aka device 1) and to a file, in this case
out. Redirect 1 to another file and you have split it all. I bet you can 'nest' it further using pipe and tee again. As long as you can spawn processes.

Kind regards,
Eric.

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