Re: SQLPLUS: Help suppressing blank line

The command you are wanting is: SET RECSEP OFF Also, you will want to add SET VERIFY OFF and add a space before REUSE.

Jeff

In article <4gilgq$427_at_news2.aimnet.com>, bfntd_at_aimnet.com says...
>
>Try setting feedback off
>
>Tony Damon
>
>Chuck Hamilton (chuckh_at_ix.netcom.com) wrote:
>: I'm using the script below to drop and recreate a tablespace. It seems
>: to be working okay except for one thing that really annoys me. It puts
>: a blank line in the output script between the 'create tablespace' and
>: first datafile line. Why? How can I suppress it?
>:
>: --------------------------[output]-----------------------------
>: alter tablespace mhp offline;
>: drop tablespace mhp including contents;
>: create tablespace mhp datafile
>:
>: '/usr/ORACLE/DRD/DATA/MHP1/mhpdrd1.dbf' size 2097152000 reuse
>: , '/usr/ORACLE/DRD/DATA/MHP1/mhpdrd2.dbf' size 1887436800 reuse
>: , '/usr/ORACLE/DRD/DATA/MHP2/mhpdrd3.dbf' size 2097152000 reuse
>: , '/usr/ORACLE/DRD/DATA/MHP2/mhpdrd4.dbf' size 1048576000 reuse
>: default storage (initial 3145728 next 3145728 pctincrease 1);
>: --------------------------[script]------------------------------
>: prompt
>: prompt This scripts drops and recreates a tablespace. It
>: prompt does not automatically recreate the objects that
>: prompt were stored in it
>: prompt
>: accept tsp prompt 'Enter tablespace to drop and recreate: '
>:
>: column x1 format a80
>: set pages 0
>: set feedback off
>: spool recreate_tablespace.sq2
>:
>: select
>: 'alter tablespace &&tsp offline;' x1,
>: 'drop tablespace &&tsp including contents;' x1,
>: 'create tablespace &&tsp datafile'
>: from
>: dual
>: /
>: select
>: decode(rownum,1,' ',', ')
>: ||''''||file_name||''' size '||bytes||'reuse'
>: from
>: sys.dba_data_files
>: where
>: tablespace_name = upper('&&tsp')
>: order by
>: file_id
>: /
>: select
>: ' default storage (initial '||initial_extent||' next '||next_extent
>: ||' pctincrease '||pct_increase||');'
>: from
>: sys.dba_tablespaces
>: where
>: tablespace_name = upper('&&tsp')
>: /
>: spool off
>:
>: rem _at_recreate_tablespace.sq2
>:
>: set feedback on
>: set pages 24
>: undefine tsp
>:
>: --
>: Chuck Hamilton
>: chuckh_at_ix.netcom.com
>:
>: If at first you don't succeed, skydiving isn't for you.
>:
 

-- 
Jeffrey S. McFarlane   Oracle DBA     Shell Services Company
http://www.lookup.com/Homepages/71915/home.html
mailto:jeffmc_at_shellus.com