set echo off
set heading off
set feedback off
SPOOL c:\temp\all_tmp.sql
select 'alter user ' || username || ' temporary tablespace TEMP;'
from dba_users where temporary_tablespace != 'TEMP';
SPOOL off...
As their name implies, locally managed tablespaces do not manage their free and used extents by the data dictionary but are instead managed at the local tablespace level. This local management is acco...
This might not be an issue which would be faced by SQL DBAs regularly because databases are generally already created. There might be few DBAs out there who take care of deployment as well. So, if you...
