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