SQL>
SQL> create table foo (a int)
2 tablespace users;
Table created.
SQL>
SQL> select table_name, tablespace_name
2 from user_tables
3 where table_name = 'FOO';
TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
FOO USERS
SQL>
SQL> select username, default_tablespace, temporary_tablespace
2 from dba_users
3 where default_tablespace = 'SYSTEM' or temporary_tablespace = 'SYSTEM';
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------------------------ ------------------------------ ------------------------------
SYSTEM SYSTEM TEMP
SYS SYSTEM TEMP
DIP SYSTEM TEMP
OUTLN SYSTEM TEMP
MDSYS SYSTEM TEMP
TSMSYS SYSTEM TEMP
6 rows selected.