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;
Josselin Joly
Déplacer des objets de type LOB dans le bon tabespace (LOB)
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;
Josselin Joly