Re: SQLPLUS: Help suppressing blank line

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.
:
Received on Thu Feb 22 1996 - 00:00:00 CET