USER_TABLESPACES

Purpose

This view displays the tablespaces that the current user can access. The columns in this view are the same as those in the DBA_TABLESPACES view, except the PLUGGED_IN column.

Columns

Sample query

Query all tablespaces that the current user can access.

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.