Show tablespaces

SQL> select tablespace_name
2 from dba_tablespaces
3 order by tablespace_name;

TABLESPACE_NAME
------------------------------
EXAMPLE
SYSAUX
SYSTEM
TEMP
UNDOTBS1
USERS

6 linhas selecionadas.