Get default table space for current user
SQL> SQL> select default_tablespace from user_users; DEFAULT_TABLESPACE ------------------------------ SYSTEM SQL>