Re: Is there a way to append spool files?

if it's a sqlplus feature there's no reason not to use a 10gr2 or 11 client against the 9i db. In fact I often recommend just this.

On Fri, Nov 28, 2008 at 10:48 AM, Pete Finnigan <pete_at_petefinnigan.com>wrote:

> Thanks everyone,
>
> so from 10gR2 we can use "append" for earlier, 9iR2 or 10gR1 we would
> have to use a pipe or use copy/cat as I first thought. The guy who asked
> me the question is on 9iR2, so whilst the append sounds great, its not
> going to work for him (yet).
>
> cheers
>
> Pete
>
> Nigel Thomas wrote:
> > If you for any reason you need to do this on an earlier version - and
> you're
> > running a *nix, you can always set up a pipe.
> >
> > I don't have a handy server to test on (Windows environment on current
> > site), but its something like:
> >
> > mknod p mypipe
> > cat mypipe >mylogfile &
> >
> > sqlplus u/p
> >
> > spool mypipe
> > logged stuff
> > spool off
> > non-logged stuff
> > spool mypipe
> > more logged stuff
> > spool off
> >
> > exit
> >
> > The pipeline will stay open - but you can kill the cat once you are done.
> > (No, it's a piece of software in the background, not a cuddly furry
> animal).
> >
> > Regards Nigel
> >
>
> --
>
> Pete Finnigan
> Director
> PeteFinnigan.com Limited
>
> Specialists in database security.
>
> If you need help to audit or secure an Oracle database, please ask for
> details of our courses and consulting services
>
> Phone: +44 (0)1904 791188
> Fax : +44 (0)1904 791188
> Mob : +44 (0)7742 114223
> email: pete_at_petefinnigan.com
> site : http://www.petefinnigan.com
>
> Registered Office: 9 Beech Grove, Acomb, York, YO26 5LD, United Kingdom
> Company No : 4664901
> VAT No. : 940 6681 14
>
> Please note that this email communication is intended only for the
> addressee and may contain confidential or privileged information. The
> contents of this email may be circulated internally within your
> organisation only and may not be communicated to third parties without
> the prior written permission of PeteFinnigan.com Limited. This email is
> not intended nor should it be taken to create any legal relations,
> contractual or otherwise.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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