How do I get a list of TABLESPACES in an Oracle DB using SYS tables?
Printable View
How do I get a list of TABLESPACES in an Oracle DB using SYS tables?
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
RBS
TEMP
TOOLS
USERS
LIVE_TABLES
LIVE_INDEXES
Thank you !!! :)