define TBS=’SIM_SIM_LOB01′
define DFSZ=’10000M’
select ‘Alter database datafile  »’||FILE_NAME|| »’ resize ‘||’&DFSZ’||’;’ from dba_data_files where TABLESPACE_NAME like ‘&TBS’ order by FILE_NAME;