Purpose
The ALL_TABLES view displays all tables accessible to the current user.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
DBA_TABLES
USER_TABLES
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the table. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table. |
| TABLESPACE_NAME | VARCHAR2(30) | NO | The name of the tablespace that contains the table. |
| CLUSTER_NAME | VARCHAR2(128) | NO | At present, this column is not supported and its value is NULL by default. |
| IOT_NAME | VARCHAR2(128) | NO | At present, this column is not supported and its value is NULL by default. |
| STATUS | VARCHAR2(8) | NO | The status of the table. Valid values: |
| PCT_FREE | NUMBER | NO | The minimum percentage of free space in a block. |
| PCT_USED | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| INI_TRANS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| MAX_TRANS | 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. |
| PCT_INCREASE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELISTS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LOGGING | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| BACKED_UP | VARCHAR2(1) | NO | At present, this column is not supported and its value is NULL by default. |
| NUM_ROWS | NUMBER | NO | The number rows in the table. |
| BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| EMPTY_BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_SPACE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| CHAIN_CNT | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_ROW_LEN | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| NUM_FREELIST_BLOCKS | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| DEGREE | VARCHAR2(10) | NO | At present, this column is not supported and its value is NULL by default. |
| INSTANCES | VARCHAR2(10) | NO | At present, this column is not supported and its value is NULL by default. |
| CACHE | VARCHAR2(5) | NO | At present, this column is not supported and its value is NULL by default. |
| TABLE_LOCK | VARCHAR2(8) | NO | At present, this column is not supported and its value is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this column is not supported and its value is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this column is not supported and its value is NULL by default. |
| PARTITIONED | VARCHAR2(3) | NO | Indicates whether the table is partitioned. Valid values: |
| IOT_TYPE | VARCHAR2(12) | NO | At present, this column is not supported and its value is NULL by default. |
| TEMPORARY | VARCHAR2(1) | NO | Indicates whether the table is a temporary table. |
| SECONDARY | VARCHAR2(1) | NO | At present, this column is not supported and its value is NULL by default. |
| NESTED | VARCHAR2(3) | NO | Indicates whether the table is a nested table. Valid values: |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| ROW_MOVEMENT | VARCHAR2(8) | NO | At present, this column is not supported and its value is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| DURATION | VARCHAR2(15) | NO | The duration of the table if it is a temporary table. |
| SKIP_CORRUPT | VARCHAR2(8) | NO | At present, this column is not supported and its value is NULL by default. |
| MONITORING | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| CLUSTER_OWNER | VARCHAR2(128) | NO | At present, this column is not supported and its value is NULL by default. |
| DEPENDENCIES | VARCHAR2(8) | NO | At present, this column is not supported and its value is NULL by default. |
| COMPRESSION | VARCHAR2(8) | NO | At present, this column is not supported and its value is NULL by default. |
| COMPRESS_FOR | VARCHAR2(30) | NO | At present, this column is not supported and its value is NULL by default. |
| DROPPED | VARCHAR2(3) | NO | Indicates whether the table has been dropped and moved to the recycle bin. |
| READ_ONLY | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this column is not supported and its value is NULL by default. |
| RESULT_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and its value is NULL by default. |
| CLUSTERING | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| ACTIVITY_TRACKING | VARCHAR2(23) | NO | At present, the value of this column is NULL by default. |
| DML_TIMESTAMP | VARCHAR2(25) | NO | At present, the value of this column is NULL by default. |
| HAS_IDENTITY | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| CONTAINER_DATA | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| INMEMORY | VARCHAR2(8) | NO | At present, the value of this column is NULL by default. |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | At present, the value of this column is NULL by default. |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | At present, the value of this column is NULL by default. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | At present, the value of this column is NULL by default. |
| DEFAULT_COLLATION | VARCHAR2(100) | NO | At present, the value of this column is NULL by default. |
| DUPLICATED | VARCHAR2(1) | NO | At present, the value of this column is NULL by default. |
| SHARDED | VARCHAR2(1) | NO | At present, the value of this column is NULL by default. |
| EXTERNALLY_SHARDED | VARCHAR2(1) | NO | At present, the value of this column is NULL by default. |
| EXTERNALLY_DUPLICATED | VARCHAR2(1) | NO | At present, the value of this column is NULL by default. |
| EXTERNAL | VARCHAR2(3) | NO | Indicates whether the table is an external table. Valid values:
|
| HYBRID | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| CELLMEMORY | VARCHAR2(24) | NO | This column is used for compatibility with Oracle. The default value of this column is NULL, which has no actual meaning. |
| CONTAINERS_DEFAULT | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| CONTAINER_MAP | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| EXTENDED_DATA_LINK | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| EXTENDED_DATA_LINK_MAP | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | At present, the value of this column is NULL by default. |
| INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | At present, the value of this column is NULL by default. |
| CONTAINER_MAP_OBJECT | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | At present, the value of this column is NULL by default. |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | At present, the value of this column is NULL by default. |
| HAS_SENSITIVE_COLUMN | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| ADMIT_NULL | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| DATA_LINK_DML_ENABLED | VARCHAR2(3) | NO | At present, the value of this column is NULL by default. |
| LOGICAL_REPLICATION | VARCHAR2(8) | NO | At present, the value of this column is NULL by default. |