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...
Introduction to Oracle 18c Express edition (XE)
Oracle 18c Express edition (XE) is a lightweight database that can be used to host small applications and is often used by students or developers to tes...