creatablespace.sql

/* This script generates the script to create tablespaces. */
spool cre_tbsp.sql
set heading off
set pagesize 1000
set linesize  80 
select 'create tablespace '||tablespace_name|| 
' datafile ''/u0?/ORACLE/xdev/'''||tablespace_name||'01.dbf '' size '
||sum(bytes)|| ';'
from sys.dba_data_files
where tablespace_name like 'PS%'
group by tablespace_name;
spool off