Note
This view is available starting with V2.2.30.
Purpose
This view displays all tablespaces in the current tenant.
Applicability
This view is available only in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace. |
| BLOCK_SIZE | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| MIN_EXTENTS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| MAX_EXTENTS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| MAX_SIZE | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| PCT_INCREASE | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| MIN_EXTLEN | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| STATUS | VARCHAR2(9) | NO | This column is not supported. The value of this column is NULL by default. |
| CONTENTS | VARCHAR2(9) | NO | This column is not supported. The value of this column is NULL by default. |
| LOGGING | VARCHAR2(9) | NO | This column is not supported. The value of this column is NULL by default. |
| FORCE_LOGGING | VARCHAR2(3) | NO | This column is not supported. The value of this column is NULL by default. |
| EXTENT_MANAGEMENT | VARCHAR2(10) | NO | This column is not supported. The value of this column is NULL by default. |
| ALLOCATION_TYPE | VARCHAR2(9) | NO | This column is not supported. The value of this column is NULL by default. |
| PLUGGED_IN | VARCHAR2(3) | NO | This column is not supported. The value of this column is NULL by default. |
| SEGMENT_SPACE_MANAGEMENT | VARCHAR2(6) | NO | This column is not supported. The value of this column is NULL by default. |
| DEF_TAB_COMPRESSION | VARCHAR2(8) | NO | Indicates whether default table compression is enabled. |
| RETENTION | VARCHAR2(11) | NO | This column is not supported. The value of this column is NULL by default. |
| BIGFILE | VARCHAR2(3) | NO | This column is not supported. The value of this column is NULL by default. |
| PREDICATE_EVALUATION | VARCHAR2(7) | NO | This column is not supported. The value of this column is NULL by default. |
| ENCRYPTED | VARCHAR2(3) | NO | This column is not supported. The value of this column is NULL by default. |
| COMPRESS_FOR | VARCHAR2(12) | NO | This column is not supported. The value of this column is NULL by default. |
Sample query
Query all tablespaces in the current tenant.
obclient [SYS]> SELECT TABLESPACE_NAME, ENCRYPTED FROM SYS.DBA_TABLESPACES;
The query result is as follows:
+-----------------+-----------+
| TABLESPACE_NAME | ENCRYPTED |
+-----------------+-----------+
| SECTEST_TS1 | YES |
| TS2 | NO |
+-----------------+-----------+
2 rows in set
References
To query the tablespaces that are accessible to the current user, query the USER_TABLESPACES view.