当前用户的缺省表空间

1）指定用户的表空间
SQL> select username,default_tablespace from dba_users where username=upper('scott');

2）当前用户的缺省表空间
SQL> select username,default_tablespace from dba_users where username=(select user from dual);

----------------------------------
例1：
SQL> select username,default_tablespace from dba_users where username=upper('scott');
USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
SCOTT                          USERS
SQL>

例2：
SQL> select username,default_tablespace from dba_users where username=(select user from dual);
USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
SYS                            SYSTEM
SQL>

----------------------------------

以上。