Purpose
The USER_TABLES view displays all tables owned by the current user.
Applicability
This view applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
References
ALL_TABLES
DBA_TABLES
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| 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 | At present, this column is not supported and its value is NULL by default. |
| 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 | At present, this column is not supported and its value is NULL by default. |
| 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. |