Show All Tablespaces in the Current Database in Oracle

Q

How To View Tablespaces in the Current Database in Oracle?

✍: FYIcenter.com

A

If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example:

SQL> connect SYSTEM/fyicenter
Connected.

SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS
  2  FROM USER_TABLESPACES;
TABLESPACE_NAME                STATUS    CONTENTS
------------------------------ --------- ---------
SYSTEM                         ONLINE    PERMANENT
UNDO                           ONLINE    UNDO
SYSAUX                         ONLINE    PERMANENT
TEMP                           ONLINE    TEMPORARY
USERS                          ONLINE    PERMANENT

 

Built-in Tablespaces in a Database in Oracle

Relation between Database and Tablespaces in Oracle

Managing Oracle Tablespaces and Data Files

⇑⇑ Oracle Database Tutorials

2019-01-20, 2062🔥, 0💬