Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I'd like how list all users that have a specific Temporary Tablespace Default.
You can use a select on dba_users
from dba_users a
TEMPORARY_TABLESPACE = '<NAME TEMP TABLESPACE>';
Required, but never shown