Note
This view is available starting with V2.2.30.
Purpose
This view displays all tables owned by the current user.
Applicability
This view is available only in Oracle mode of OceanBase Database.
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 | This column is not supported. The default value is NULL. |
| IOT_NAME | VARCHAR2(128) | NO | This column is not supported. The default value is NULL. |
| 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 | This column is not supported. The default value is NULL. |
| INI_TRANS | NUMBER | NO | This column is not supported. The default value is NULL. |
| MAX_TRANS | NUMBER | NO | This column is not supported. The default value is NULL. |
| INITIAL_EXTENT | NUMBER | NO | This column is not supported. The default value is NULL. |
| NEXT_EXTENT | NUMBER | NO | This column is not supported. The default value is NULL. |
| MIN_EXTENTS | NUMBER | NO | This column is not supported. The default value is NULL. |
| MAX_EXTENTS | NUMBER | NO | This column is not supported. The default value is NULL. |
| PCT_INCREASE | NUMBER | NO | This column is not supported. The default value is NULL. |
| FREELISTS | NUMBER | NO | This column is not supported. The default value is NULL. |
| FREELIST_GROUPS | NUMBER | NO | This column is not supported. The default value is NULL. |
| LOGGING | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| BACKED_UP | VARCHAR2(1) | NO | This column is not supported. The default value is NULL. |
| NUM_ROWS | NUMBER | NO | The number of rows in the table. |
| BLOCKS | NUMBER | NO | This column is not supported. The default value is NULL. |
| EMPTY_BLOCKS | NUMBER | NO | This column is not supported. The default value is NULL. |
| AVG_SPACE | NUMBER | NO | This column is not supported. The default value is NULL. |
| CHAIN_CNT | NUMBER | NO | This column is not supported. The default value is NULL. |
| AVG_ROW_LEN | NUMBER | NO | This column is not supported. The default value is NULL. |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | NO | This column is not supported. The default value is NULL. |
| NUM_FREELIST_BLOCKS | NUMBER | NO | This column is not supported. The default value is NULL. |
| DEGREE | VARCHAR2(10) | NO | This column is not supported. The default value is NULL. |
| INSTANCES | VARCHAR2(10) | NO | This column is not supported. The default value is NULL. |
| CACHE | VARCHAR2(5) | NO | This column is not supported. It is NULL by default. |
| TABLE_LOCK | VARCHAR2(8) | NO | This column is not supported. It is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | This column is not supported. It is NULL by default. |
| LAST_ANALYZED | DATE | NO | This column is not supported. It is NULL by default. |
| PARTITIONED | VARCHAR2(3) | NO | This column is not supported. It is NULL by default. |
| IOT_TYPE | VARCHAR2(12) | NO | This column is not supported. It is NULL by default. |
| TEMPORARY | VARCHAR2(1) | NO | Indicates whether the table is a temporary table. |
| SECONDARY | VARCHAR2(1) | NO | This column is not supported. It is NULL by default. |
| NESTED | VARCHAR2(3) | NO | This column is not supported. It is NULL by default. |
| BUFFER_POOL | VARCHAR2(7) | NO | This column is not supported. It is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported. It is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported. It is NULL by default. |
| ROW_MOVEMENT | VARCHAR2(8) | NO | This column is not supported. It is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | This column is not supported. It is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | This column is not supported. It is NULL by default. |
| DURATION | VARCHAR2(15) | NO | Indicates the duration of the temporary table. |
| SKIP_CORRUPT | VARCHAR2(8) | NO | This column is not supported. It is NULL by default. |
| MONITORING | VARCHAR2(3) | NO | This column is not supported. It is NULL by default. |
| CLUSTER_OWNER | VARCHAR2(128) | NO | This column is not supported. It is NULL by default. |
| DEPENDENCIES | VARCHAR2(8) | NO | This column is not supported. It is NULL by default. |
| COMPRESSION | VARCHAR2(8) | NO | This column is not supported. It is NULL by default. |
| COMPRESS_FOR | VARCHAR2(30) | NO | This column is not supported. It is NULL by default. |
| DROPPED | VARCHAR2(3) | NO | Indicates whether the dropped table is in the recycle bin. |
| READ_ONLY | VARCHAR2(3) | NO | This column is not supported. It is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | This column is not supported. It is NULL by default. |
| RESULT_CACHE | VARCHAR2(7) | NO | This column is not supported. It is NULL by default. |
| CLUSTERING | VARCHAR2(3) | NO | This column is NULL by default. |
| ACTIVITY_TRACKING | VARCHAR2(23) | NO | This column is NULL by default. |
| DML_TIMESTAMP | VARCHAR2(25) | NO | This column is NULL by default. |
| HAS_IDENTITY | VARCHAR2(3) | NO | This column is NULL by default. |
| CONTAINER_DATA | VARCHAR2(3) | NO | This column is NULL by default. |
| INMEMORY | VARCHAR2(8) | NO | This column is compatible with Oracle. It is NULL and has no practical meaning. |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | This column is compatible with Oracle. It is NULL and has no practical meaning. |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | A compatibility field with Oracle. The value is NULL and has no actual meaning. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | A compatibility field with Oracle. The value is NULL and has no actual meaning. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | A compatibility field with Oracle. The value is NULL and has no actual meaning. |
| DEFAULT_COLLATION | VARCHAR2(100) | NO | The default value of this field is NULL. |
| DUPLICATED | VARCHAR2(1) | NO | The default value of this field is NULL. |
| SHARDED | VARCHAR2(1) | NO | The default value of this field is NULL. |
| EXTERNALLY_SHARDED | VARCHAR2(1) | NO | The default value of this field is NULL. |
| EXTERNALLY_DUPLICATED | VARCHAR2(1) | NO | The default value of this field is NULL. |
| EXTERNAL | VARCHAR2(3) | NO | Indicates whether the table is an external table:
|
| HYBRID | VARCHAR2(3) | NO | The default value of this field is NULL. |
| CELLMEMORY | VARCHAR2(24) | NO | A compatibility field with Oracle. The value is NULL and has no actual meaning. |
| CONTAINERS_DEFAULT | VARCHAR2(3) | NO | The default value of this field is NULL. |
| CONTAINER_MAP | VARCHAR2(3) | NO | The default value of this field is NULL. |
| EXTENDED_DATA_LINK | VARCHAR2(3) | NO | The default value of this field is NULL. |
| EXTENDED_DATA_LINK_MAP | VARCHAR2(3) | NO | The default value of this field is NULL. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | A compatibility field with Oracle. The value is NULL and has no actual meaning. |
| INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | A compatibility field with Oracle. The value is NULL and has no actual meaning. |
| CONTAINER_MAP_OBJECT | VARCHAR2(3) | NO | The default value of this field is NULL. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | The default value of this field is NULL. |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | The default value of this field is NULL. |
| HAS_SENSITIVE_COLUMN | VARCHAR2(3) | NO | The default value of this field is NULL. |
| ADMIT_NULL | VARCHAR2(3) | NO | The default value of this field is NULL. |
| DATA_LINK_DML_ENABLED | VARCHAR2(3) | NO | The default value of this field is NULL. |
| LOGICAL_REPLICATION | VARCHAR2(8) | NO | The default value of this field is NULL. |
| AUTO_SPLIT | VARCHAR2(16) | NO | Indicates whether the table is enabled for automatic partitioning. Valid values:
NoteThis field is available starting with V4.3.4. |
| AUTO_SPLIT_TABLET_SIZE | VARCHAR2(128) | NO | The threshold for automatic partition splitting. When the value of the AUTO_SPLIT field is FALSE, the value of the AUTO_SPLIT_TABLET_SIZE field is 0.
NoteThis field is available starting with V4.3.4. |
Sample query
Query the information about the TBL1 table in the current user's schema.
obclient [SYS]> SELECT TABLE_NAME, STATUS, PCT_FREE, TEMPORARY, NESTED, ROW_MOVEMENT, DROPPED, EXTERNAL FROM SYS.USER_TABLES WHERE TABLE_NAME = 'TBL1';
The query result is as follows:
+------------+--------+----------+-----------+--------+--------------+---------+----------+
| TABLE_NAME | STATUS | PCT_FREE | TEMPORARY | NESTED | ROW_MOVEMENT | DROPPED | EXTERNAL |
+------------+--------+----------+-----------+--------+--------------+---------+----------+
| TBL1 | VALID | 0 | N | NO | NO | NO | NO |
+------------+--------+----------+-----------+--------+--------------+---------+----------+
1 row in set