Purpose
The USER_TABLES view displays all tables owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
ALL_TABLESDBA_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 containing the table. |
| CLUSTER_NAME | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| IOT_NAME | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| 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 | At present, this column is not supported and is NULL by default. |
| INI_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| MAX_TRANS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| MIN_EXTENTS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| MAX_EXTENTS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| PCT_INCREASE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| FREELISTS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| LOGGING | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| BACKED_UP | VARCHAR2(1) | NO | At present, this column is not supported and is NULL by default. |
| NUM_ROWS | NUMBER | NO | The number of rows in the table. |
| BLOCKS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| EMPTY_BLOCKS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| AVG_SPACE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| CHAIN_CNT | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| AVG_ROW_LEN | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| NUM_FREELIST_BLOCKS | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| DEGREE | VARCHAR2(10) | NO | At present, this column is not supported and is NULL by default. |
| INSTANCES | VARCHAR2(10) | NO | At present, this column is not supported and is NULL by default. |
| CACHE | VARCHAR2(5) | NO | At present, this column is not supported and is NULL by default. |
| TABLE_LOCK | VARCHAR2(8) | NO | At present, this column is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | At present, this column is not supported and is NULL by default. |
| LAST_ANALYZED | DATE | NO | At present, this column is not supported and is NULL by default. |
| PARTITIONED | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| IOT_TYPE | VARCHAR2(12) | NO | At present, this column is not supported and 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 is NULL by default. |
| NESTED | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| ROW_MOVEMENT | VARCHAR2(8) | NO | At present, this column is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| DURATION | VARCHAR2(15) | NO | The duration of a temporary table. |
| SKIP_CORRUPT | VARCHAR2(8) | NO | At present, this column is not supported and is NULL by default. |
| MONITORING | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| CLUSTER_OWNER | VARCHAR2(128) | NO | At present, this column is not supported and is NULL by default. |
| DEPENDENCIES | VARCHAR2(8) | NO | At present, this column is not supported and is NULL by default. |
| COMPRESSION | VARCHAR2(8) | NO | At present, this column is not supported and is NULL by default. |
| COMPRESS_FOR | VARCHAR2(30) | NO | At present, this column is not supported and 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 is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | At present, this column is not supported and is NULL by default. |
| RESULT_CACHE | VARCHAR2(7) | NO | At present, this column is not supported and is NULL by default. |
| CLUSTERING | VARCHAR2(3) | NO | Indicates whether the table has attribute clustering clauses. Valid values: |
| ACTIVITY_TRACKING | VARCHAR2(23) | NO | Indicates whether heatmap tracking is enabled on the table. |
| DML_TIMESTAMP | VARCHAR2(25) | NO | The time when the automatic data optimization policy was created or modified. |
| HAS_IDENTITY | VARCHAR2(3) | NO | Indicates whether the table has an identifier column. Valid values: |
| CONTAINER_DATA | VARCHAR2(3) | NO | Indicates whether the table contains container-specific data. Valid values: |
| INMEMORY | VARCHAR2(8) | NO | Indicates whether in-memory column store is enabled for the table. Valid values: |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | The padding priority of the in-memory column store. Valid values: |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | The distribution of in-memory column store in a Real Application Clusters (RAC) environment. Valid values: |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | The compression level for in-memory column store. Valid values: This value is based on the location of the middle section of the table. For example, if the table is partitioned and in-memory column store is enabled, the value for ALL_TABLES is NULL and the value for ALL_TAB_SUBPARTITIONS is not NULL. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | The duplicate settings for in-memory column store in the RAC environment. Valid values: |
| DEFAULT_COLLATION | VARCHAR2(100) | NO | The default sorting rule of the table. |
| DUPLICATED | VARCHAR2(1) | NO | Indicates whether the table is duplicated on this shard. Valid values: |
| SHARDED | VARCHAR2(1) | NO | Indicates whether the table is sharded. Valid values: |
| EXTERNALLY_SHARDED | VARCHAR2(1) | NO | Indicates whether the table involves an external shard. Valid values: |
| EXTERNALLY_DUPLICATED | VARCHAR2(1) | NO | Indicates whether the table involves an external duplicate. Valid values: |
| EXTERNAL | VARCHAR2(3) | NO | Indicates whether the table is an external table. Valid values: |
| HYBRID | VARCHAR2(3) | NO | Indicates whether the table is a hybrid partitioned table. Valid values: A hybrid partition table can contain both partitions stored in a segment and partitions stored externally. |
| CELLMEMORY | VARCHAR2(24) | NO | The column compression value in the flash cache of the storage unit. Valid values:ENABLED: Oracle Exadata Storage will automatically determine whether to cache data as a column.DISABLED: Oracle Exadata Storage is prevented from caching data as a column.NO CACHECOMPRESS: Oracle Exadata Storage will cache data in HCC format (where no re-compression is required).FOR QUERY: Oracle Exadata Storage will recompress and cache data in high INMEMORY query format.FOR CAPACITY: Exadata Storage will recompress and cache data in low INMEMORY capacity format. This column is mainly used with Exadata. |
| CONTAINERS_DEFAULT | VARCHAR2(3) | NO | Indicates whether CONTAINERS() is enabled for the table by default. Valid values: |
| CONTAINER_MAP | VARCHAR2(3) | NO | Indicates whether the table is enabled and used together with the database attribute container_map. Valid values: |
| EXTENDED_DATA_LINK | VARCHAR2(3) | NO | Indicates whether obtaining extended data links from the root is enabled for the table. Valid values: |
| EXTENDED_DATA_LINK_MAP | VARCHAR2(3) | NO | For internal use only. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | The way that in-memory column store is padded on various instances. Valid values:DEFAULTPARALLEL_INSTANCE_GROUP: Data is padded on all instances specified by the initialization parameter. This is the default value. If this parameter is not set, data is padded for all instances.NONE: Data is not padded for any instance.ALL: Data is padded for all instances regardless of the settings of the initialization parameter PARALLEL_INSTANCE_GROUP.USER_DEFINED: Data is padded only for instances where the user-defined service is active. The service name is saved in the INMEMORY_SERVICE_NAME column. |
| INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | The name of the service on which in-memory column store is padded. This column has values only when INMEMORY_SERVICE is set to USER_DEFINED, and is empty in other cases. |
| CONTAINER_MAP_OBJECT | VARCHAR2(3) | NO | Indicates whether the table is used as the value of the database container_map property. Valid values: |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | Indicates whether shortcut-based access is enabled for the table. Valid values: |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | For internal use only. |
| HAS_SENSITIVE_COLUMN | VARCHAR2(3) | NO | Indicates whether the table has one or more sensitive columns. Valid values: |
| ADMIT_NULL | VARCHAR2(3) | NO | Indicates whether the table accepts empty CON_ID data. Valid values: |
| DATA_LINK_DML_ENABLED | VARCHAR2(3) | NO | Indicates whether DML is allowed on the data link table. Valid values: |
| LOGICAL_REPLICATION | VARCHAR2(8) | NO | Indicates whether logical replication is enabled for the table. Valid values: This value is ignored if the log entry of column data replenishment is enabled across the database. |