How can I determine the name of an oracle tablespace?

To retrieve the tablespace names and other related information in an Oracle database, you can use the following SQL statement:

SELECT tablespace_name, contents, status, logging, extent_management FROM dba_tablespaces;

This will return detailed information on the names of all tablespaces in the database and their content types (permanent or temporary), status, logging mode, and extent management method.

If you only want to query the table spaces owned by specific users, you can add a WHERE clause to the query.

SELECT tablespace_name, contents, status, logging, extent_management 
FROM dba_tablespaces
WHERE owner = 'YOUR_USERNAME';

Please replace `YOUR_USERNAME` with the username you want to search for. This will return detailed information about the table spaces owned by that user.