USER_TABLESPACES

Purpose

This view displays the tablespaces that are accessible to the current user. The columns of this view are the same as those of the DBA_TABLESPACES view, except that the PLUGGED_IN column is removed.

Columns

Sample query

Query all tablespaces that are accessible to the current user.

obclient [SYS]> SELECT TABLESPACE_NAME, ENCRYPTED FROM SYS.USER_TABLESPACES;

The query result is as follows:

+-----------------+-----------+
| TABLESPACE_NAME | ENCRYPTED |
+-----------------+-----------+
| SECTEST_TS1     | YES       |
| TS2             | NO        |
+-----------------+-----------+
2 rows in set

References

To query all tablespaces in the current tenant, query the DBA_TABLESPACES view.