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@xxxxxxxxxxxxxxxx>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@xxxxxxxxxxxxxxxx > 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. > > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info