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;
« Maîtrisez vos idées, optimisez vos bases.»
« Maîtrisez vos idées, optimisez vos bases.»
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;
Laisser un commentaire