USER_TABLESPACES

Purpose

This view displays the tablespaces accessible to the current user. It has the same columns as DBA_TABLESPACES, but without the PLUGGED_IN column.

Columns

Sample query

Query all tablespaces 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 under the current tenant, query the DBA_TABLESPACES view.