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 value of this column is NULL by default. |
| IOT_NAME | VARCHAR2(128) | NO | This column is not supported. The value of this column 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 | This column is not supported. The value of this column is NULL by default. |
| INI_TRANS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| MAX_TRANS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| INITIAL_EXTENT | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| NEXT_EXTENT | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| MIN_EXTENTS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| MAX_EXTENTS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| PCT_INCREASE | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| FREELISTS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| FREELIST_GROUPS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| LOGGING | VARCHAR2(3) | NO | This column is not supported. The value of this column is NULL by default. |
| BACKED_UP | VARCHAR2(1) | NO | This column is not supported. The value of this column is NULL by default. |
| NUM_ROWS | NUMBER | NO | The number of rows in the table. |
| BLOCKS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| EMPTY_BLOCKS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| AVG_SPACE | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| CHAIN_CNT | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| AVG_ROW_LEN | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| NUM_FREELIST_BLOCKS | NUMBER | NO | This column is not supported. The value of this column is NULL by default. |
| DEGREE | VARCHAR2(10) | NO | This column is not supported. The value of this column is NULL by default. |
| INSTANCES | VARCHAR2(10) | NO | This column is not supported. The value of this column is NULL by default. |
| CACHE | VARCHAR2(5) | NO | This column is not supported. The default value is NULL. |
| TABLE_LOCK | VARCHAR2(8) | NO | This column is not supported. The default value is NULL. |
| SAMPLE_SIZE | NUMBER | NO | This column is not supported. The default value is NULL. |
| LAST_ANALYZED | DATE | NO | This column is not supported. The default value is NULL. |
| PARTITIONED | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| IOT_TYPE | VARCHAR2(12) | NO | This column is not supported. The default value is NULL. |
| TEMPORARY | VARCHAR2(1) | NO | Indicates whether the table is a temporary table. |
| SECONDARY | VARCHAR2(1) | NO | This column is not supported. The default value is NULL. |
| NESTED | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| BUFFER_POOL | VARCHAR2(7) | NO | This column is not supported. The default value is NULL. |
| FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported. The default value is NULL. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported. The default value is NULL. |
| ROW_MOVEMENT | VARCHAR2(8) | NO | Indicates whether Row Movement is enabled or disabled. Valid values:
Note
|
| GLOBAL_STATS | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| USER_STATS | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| DURATION | VARCHAR2(15) | NO | Indicates the duration of the temporary table. |
| SKIP_CORRUPT | VARCHAR2(8) | NO | This column is not supported. The default value is NULL. |
| MONITORING | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| CLUSTER_OWNER | VARCHAR2(128) | NO | This column is not supported. The default value is NULL. |
| DEPENDENCIES | VARCHAR2(8) | NO | This column is not supported. The default value is NULL. |
| COMPRESSION | VARCHAR2(8) | NO | This column is not supported. The default value is NULL. |
| COMPRESS_FOR | VARCHAR2(30) | NO | This column is not supported. The default value is NULL. |
| DROPPED | VARCHAR2(3) | NO | Indicates whether the dropped table is in the recycle bin. |
| READ_ONLY | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | This column is not supported. The default value is NULL. |
| RESULT_CACHE | VARCHAR2(7) | NO | This column is not supported. The default value is NULL. |
| CLUSTERING | VARCHAR2(3) | NO | The default value is NULL. |
| ACTIVITY_TRACKING | VARCHAR2(23) | NO | The default value is NULL. |
| DML_TIMESTAMP | VARCHAR2(25) | NO | The default value is NULL. |
| HAS_IDENTITY | VARCHAR2(3) | NO | The default value is NULL |
| CONTAINER_DATA | VARCHAR2(3) | NO | This column is NULL by default. |
| INMEMORY | VARCHAR2(8) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. |
| DEFAULT_COLLATION | VARCHAR2(100) | NO | This column is NULL by default. |
| DUPLICATED | VARCHAR2(1) | NO | This column is NULL by default. |
| SHARDED | VARCHAR2(1) | NO | This column is NULL by default. |
| EXTERNALLY_SHARDED | VARCHAR2(1) | NO | This column is NULL by default. |
| EXTERNALLY_DUPLICATED | VARCHAR2(1) | NO | This column is NULL by default. |
| EXTERNAL | VARCHAR2(3) | NO | Indicates whether the table is an external table: |
| HYBRID | VARCHAR2(3) | NO | This column is NULL by default. |
| CELLMEMORY | VARCHAR2(24) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. |
| CONTAINERS_DEFAULT | VARCHAR2(3) | NO | This column is NULL by default. |
| CONTAINER_MAP | VARCHAR2(3) | NO | This column is NULL by default. |
| EXTENDED_DATA_LINK | VARCHAR2(3) | NO | This column is NULL by default. |
| EXTENDED_DATA_LINK_MAP | VARCHAR2(3) | NO | This column is NULL by default. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. |
| INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. |
| CONTAINER_MAP_OBJECT | VARCHAR2(3) | NO | This column is NULL by default. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | This column is NULL by default. |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | This column is NULL by default. |
| HAS_SENSITIVE_COLUMN | VARCHAR2(3) | NO | This column is NULL by default. |
| ADMIT_NULL | VARCHAR2(3) | NO | This column is NULL by default. |
| DATA_LINK_DML_ENABLED | VARCHAR2(3) | NO | This column is NULL by default. |
| LOGICAL_REPLICATION | VARCHAR2(8) | NO | This column is NULL by default. |
| AUTO_SPLIT | VARCHAR2(16) | NO | Indicates whether automatic partitioning is enabled for the table. Valid values:
NoteThis column is available starting with V4.3.4. |
| AUTO_SPLIT_TABLET_SIZE | VARCHAR2(128) | NO | Indicates the automatic partitioning threshold. When the value of the AUTO_SPLIT column is FALSE, the value of the AUTO_SPLIT_TABLET_SIZE column is 0.
NoteThis column is available starting with V4.3.4. |
Sample query
Query the information about the TBL1 table in the tables owned by the current user.
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