Purpose
The USER_TABLESPACES view displays the tablespaces accessible to the current user. Its columns are the same as those of the DBA_TABLESPACES view, except that it does not have the PLUGGED_IN column.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
DBA_TABLESPACES
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace. |
| BLOCK_SIZE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MIN_EXTENTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_EXTENTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_SIZE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| PCT_INCREASE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MIN_EXTLEN | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| STATUS | VARCHAR2(9) | NO | At present, this column is not supported and its value is NULL by default. |
| CONTENTS | VARCHAR2(9) | NO | At present, this column is not supported and its value is NULL by default. |
| LOGGING | VARCHAR2(9) | NO | At present, this column is not supported and its value is NULL by default. |
| FORCE_LOGGING | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| EXTENT_MANAGEMENT | VARCHAR2(10) | NO | At present, this column is not supported and its value is NULL by default. |
| ALLOCATION_TYPE | VARCHAR2(9) | NO | At present, this column is not supported and its value is NULL by default. |
| SEGMENT_SPACE_MANAGEMENT | VARCHAR2(6) | NO | At present, this column is not supported and its value is NULL by default. |
| DEF_TAB_COMPRESSION | VARCHAR2(8) | NO | Indicates whether default table compression is enabled. |
| RETENTION | VARCHAR2(11) | NO | At present, this column is not supported and its value is NULL by default. |
| BIGFILE | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| PREDICATE_EVALUATION | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| ENCRYPTED | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| COMPRESS_FOR | VARCHAR2(12) | NO | At present, this column is not supported and its value is NULL by default. |