— cre_alt_usr_ts.sql
— mdw 02/02/00
— create alt_usr_ts.sql to alter all users to new temp ts
set pause off
set head off
set feed off veri off
accept ts_name prompt ‘what tablespace are users to be swapped to? >’
spool alt_usr_ts.sql
select ‘alter user ‘||username||’ temporary tablespace ‘||
       nvl(‘&ts_name’,’TEMP_02′)||’;’
from dba_users
where temporary_tablespace like ‘T%’
/
undefine ts_name
spool off
set head on veri on
set pause on
set pause ‘Any Key…>’
set feed on