set feedback off
set linesize 300
set pagesize 0
spool test1.sql
select 'alter database datafile '''file_name''' autoextend off;' from dba_data_files where autoextensible='YES' and (tablespace_name like '%TEMP%' OR tablespace_name like '%UNDO%' OR tablespace_name like '%RBS%');
spool off
@test1.sql
We can use the script changing the tablespace name or just remove query after 'and' for doing with rest of tablespaces....
No comments:
Post a Comment