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...
The selectivity of an index is defined as the fraction of rows in a table having the same value for the indexed key. A highly selective index has few rows for each index entry and an unselective inde...
