Re: getting junk out of spool file

Nathan wrote:
>
> Hi All,
>
> I ran the following script on a Sun box 18 months ago using
> Oracle 8.something and it worked great. I run it
> on my PC in sqlplus 8.0.6.0.0 connected to Oracle 8.1.5
> on a Sun and I got errors.
>
> --------------------------------------------------
> set timing off
> set time off
> set feedback off
> set heading off
> set echo off
> ttitle off
> btitle off
> set line 80
> set pages 0
> set recsep off
>
> spool disable_cons.lst
>
> select 'alter table '||TABLE_NAME||' disable constraint '||CONSTRAINT_NAME||';'
> from user_constraints
> where CONSTRAINT_TYPE = 'R'
> order by TABLE_NAME, CONSTRAINT_NAME;
>
> spool off
>
> set feedback on
> set heading on
> set echo on
> set line 80
> set pages 30
>
> start disable_cons.lst
> -----------------------------------------------------
>
> The contents of disable_cons.lst are:
>
> -----------------------------------------------------
> SQL> select 'alter table '||TABLE_NAME||' disable constraint '||
> CONSTRAINT_NAME||';'
> 2 from user_constraints
> 3 where CONSTRAINT_TYPE = 'R'
> 4 order by TABLE_NAME, CONSTRAINT_NAME;
> alter table TRANSFER disable constraint TRANSFER_ALLOCATION_FK;
> SQL> spool off
> -----------------------------------------------------
>
> That explains the errors. How do I turn off the output of the SQL> prompt and
> the stuff I don't need? All I want in my file is:
>
> ------------------------------------------------------
> alter table TRANSFER disable constraint TRANSFER_ALLOCATION_FK;
> ------------------------------------------------------
>
> and a statement for any other constraints (without the ---- of course)
>
> Thanks for any suggestions you can give.
>
> Nathan

Try 'set termout off' or

select blah (no semicolon)
<= deliberate blank line
spool x
/
spool off

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"