Note
This view is available starting with V2.2.30.
Purpose
This view displays all tablespaces in the current tenant.
Applicability
This view applies only to OceanBase Database 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 accessible to the current user, query the USER_TABLESPACES view.