alt_temp.sql

select 'alter user ' || username || '   temporary tablespace temp;'
from dba_users where temporary_tablespace='SYSTEM'
/