How can we view the names of tablespaces in Oracle?

1 year ago
Noah Thompson
1 minute

To view the tablespace names in an Oracle database, you can utilize the following SQL query:

SELECT tablespace_name 
FROM dba_tablespaces;

This SQL statement will retrieve the names of all table spaces in the database. To view the table space names for a specific user, you can use the following SQL query:

SELECT tablespace_name 
FROM dba_tablespaces
WHERE owner = 'your_username';

Replace “your_username” with the username you want to search for.

bannerAds