Re: Is there a way to append spool files?
Date: Fri, 28 Nov 2008 10:48:35 +0000
Message-ID: <492FCC83.3070605@petefinnigan.com>
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-lReceived on Fri Nov 28 2008 - 04:48:35 CST