Thursday, December 18, 2008

Script to set all TEMP, UNDO and RBS Tablespace autoextend off....

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: