SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
RBS
TEMP
TOOLS
USERS
LIVE_TABLES
LIVE_INDEXES