SQLPLUS: Help suppressing blank line
Date: 1996/02/21
Message-ID: <4gfh66$f9o_at_ixnews4.ix.netcom.com>#1/1
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?
column x1 format a80
select
--------------------------[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: '
set pages 0
set feedback off
spool recreate_tablespace.sq2
'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 Wed Feb 21 1996 - 00:00:00 CET