Oracle PL/SQL/System Tables Views/user users
select default_tablespace from user_users
<source lang="sql">
SQL> SQL> select default_tablespace from user_users; DEFAULT_TABLESPACE
SYSTEM
</source>
<source lang="sql">
SQL> SQL> select default_tablespace from user_users; DEFAULT_TABLESPACE
SYSTEM
</source>