建表空间脚本

set echo off; 
set feedback off; 
set colsep |; 
set linesize 2500; 
set pagesize 0; 
set heading off; 
set term off; 
set trimspool on; 
set trimout on;
set numformat 99999999990.99; 
set sqlnumber off; 

spool D:\1ctbs.sql


select 'create tablespace   '||tablespace_name|| '  datafile  ''' ||file_name|| ''' size ' ||bytes/1048576|| 'M;'  from   dba_data_files where tablespace_name not in('USERS','SYSAUX','UNDOTBS1','SYSTEM','CWMLITE','DRSYS','EXAMPLE','INDX','ODM','TOOLS','XDB' ) order by tablespace_name;


spool off