Purpose
The DBA_TABLESPACES view displays all the tablespaces in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
USER_TABLESPACES
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace. |
| BLOCK_SIZE | NUMBER | NO | The size of the tablespace block. At present, this column is not supported and is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | The initial extent size by default. At present, this column is not supported and is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | The incremental extent size by default. At present, this column is not supported and is NULL by default. |
| MIN_EXTENTS | NUMBER | NO | The minimum number of extents by default. At present, this column is not supported and is NULL by default. |
| MAX_EXTENTS | NUMBER | NO | The maximum number of extents by default. At present, this column is not supported and is NULL by default. |
| MAX_SIZE | NUMBER | NO | The maximum segment size by default. At present, this column is not supported and is NULL by default. |
| PCT_INCREASE | NUMBER | NO | The default percentage increase in extent size. At present, this column is not supported and is NULL by default. |
| MIN_EXTLEN | NUMBER | NO | The minimum extent size for this tablespace. At present, this column is not supported and is NULL by default. |
| STATUS | VARCHAR2(9) | NO | The tablespace status. Valid values: At present, this column is not supported and is NULL by default. |
| CONTENTS | VARCHAR2(9) | NO | The tablespace content. Valid values: At present, this column is not supported and is NULL by default. |
| LOGGING | VARCHAR2(9) | NO | The default logging attribute. Valid values: At present, this column is not supported and is NULL by default. |
| FORCE_LOGGING | VARCHAR2(3) | NO | Indicates whether the tablespace is in force logging mode. At present, this column is not supported and is NULL by default. |
| EXTENT_MANAGEMENT | VARCHAR2(10) | NO | Indicates whether the extents in the tablespace are dictionary-managed or locally managed. At present, this column is not supported and is NULL by default. |
| ALLOCATION_TYPE | VARCHAR2(9) | NO | The effective extent allocation type in the tablespace. Valid values: At present, this column is not supported and is NULL by default. |
| PLUGGED_IN | VARCHAR2(3) | NO | Indicates whether the free and used segment space in the tablespace is managed using free lists or bitmaps. At present, this column is not supported and is NULL by default. |
| SEGMENT_SPACE_MANAGEMENT | VARCHAR2(6) | NO | Indicates whether the free and used segment space in the tablespace is managed using free lists or bitmaps. At present, this column is not supported and is NULL by default. |
| DEF_TAB_COMPRESSION | VARCHAR2(8) | NO | Indicates whether default table compression is enabled. |
| RETENTION | VARCHAR2(11) | NO | The undo tablespace retention. Valid values: At present, this column is not supported and is NULL by default. |
| BIGFILE | VARCHAR2(3) | NO | Indicates whether the tablespace is a bigfile tablespace or a smallfile tablespace. At present, this column is not supported and is NULL by default. |
| PREDICATE_EVALUATION | VARCHAR2(7) | NO | Indicates whether the predicate is computed by the host or storage. At present, this column is not supported and is NULL by default. |
| ENCRYPTED | VARCHAR2(3) | NO | Indicates whether the tablespace is encrypted. At present, this column is not supported and is NULL by default. |
| COMPRESS_FOR | VARCHAR2(12) | NO | The type of operations for which default compression is enabled. At present, this column is not supported and is NULL by default. |