Note
This view is available starting with V2.2.30.
Purpose
This view displays the object tables and relationship tables owned by the current user, with the exception of the OWNER column, which is the same as the ALL_ALL_TABLES view.
Applicability
This view applies only to the Oracle-compatible 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:
|
| 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(40) | NO | This column is not supported. The default value is NULL. |
| INSTANCES | VARCHAR2(40) | NO | This column is not supported. The default value is NULL. |
| CACHE | VARCHAR2(20) | 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 | Specifies whether the table is partitioned: |
| IOT_TYPE | VARCHAR2(12) | NO | This column is not supported. The default value is NULL. |
| OBJECT_ID_TYPE | VARCHAR2(16) | NO | This column is not supported. The default value is NULL. |
| TABLE_TYPE_OWNER | VARCHAR2(128) | NO | This column is not supported. The default value is NULL. |
| TABLE_TYPE | VARCHAR2(128) | NO | This column is not supported. The default value is NULL. |
| TEMPORARY | VARCHAR2(1) | NO | Specifies 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 | Specifies whether the table is a nested table: |
| 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 | Records the enabled/disabled status of Row Movement, with the following 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 | 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(30) | 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(12) | NO | This column is not supported. The default value is NULL. |
| DROPPED | VARCHAR2(3) | NO | Specifies whether the 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. |
Sample query
The following example shows the information about the T_SUBPART table in the object and relationship tables of the current user.
obclient [SYS]> SELECT TABLE_NAME, STATUS, PCT_FREE, NUM_ROWS, PARTITIONED, TEMPORARY, ROW_MOVEMENT, DROPPED, EXTERNAL FROM SYS.USER_ALL_TABLES WHERE TABLE_NAME='T_SUBPART';
The query result is as follows:
+------------+--------+----------+----------+-------------+-----------+--------------+---------+----------+
| TABLE_NAME | STATUS | PCT_FREE | NUM_ROWS | PARTITIONED | TEMPORARY | ROW_MOVEMENT | DROPPED | EXTERNAL |
+------------+--------+----------+----------+-------------+-----------+--------------+---------+----------+
| T_SUBPART | VALID | 0 | 1000 | YES | N | NO | NO | NO |
+------------+--------+----------+----------+-------------+-----------+--------------+---------+----------+
1 row in set
References
DBA_ALL_TABLES: shows all object and relationship tables of the current tenant.
ALL_ALL_TABLES: shows all object and relationship tables that the current user can access.