Oracle PL/SQL/System Tables Views/user users

select default_tablespace from user_users

 
SQL>
SQL> select default_tablespace from user_users;
DEFAULT_TABLESPACE
------------------------------
SYSTEM