Get names of all tablespaces from Oracle database

To get names of all tablespaces from Oracle database you can use: USER_TABLESPACES, DBA_TABLESPACES.

  
SELECT * FROM USER_TABLESPACES;

SELECT * FROM DBA_TABLESPACES;