Note
This view is available starting with V2.2.30.
Purpose
This view displays all object tables and relational tables under the current tenant. The columns of this view are the same as those of the ALL_ALL_TABLES view.
Applicability
This view applies only to the Oracle-compatible mode of OceanBase Database.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the table. |
| 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 field is not supported. The default value of this field is NULL. |
| IOT_NAME | VARCHAR2(128) | NO | This field is not supported. The default value of this field 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 field is not supported. The default value of this field is NULL. |
| INI_TRANS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| MAX_TRANS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| INITIAL_EXTENT | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| NEXT_EXTENT | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| MIN_EXTENTS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| MAX_EXTENTS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| PCT_INCREASE | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| FREELISTS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| FREELIST_GROUPS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| LOGGING | VARCHAR2(3) | NO | This field is not supported. The default value of this field is NULL. |
| BACKED_UP | VARCHAR2(1) | NO | This field is not supported. The default value of this field is NULL. |
| NUM_ROWS | NUMBER | NO | The number of rows in the table. |
| BLOCKS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| EMPTY_BLOCKS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| AVG_SPACE | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| CHAIN_CNT | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| AVG_ROW_LEN | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| NUM_FREELIST_BLOCKS | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| DEGREE | VARCHAR2(40) | NO | This field is not supported. The default value of this field is NULL. |
| INSTANCES | VARCHAR2(40) | NO | This field is not supported. The default value of this field is NULL. |
| CACHE | VARCHAR2(20) | NO | This field is not supported. The default value of this field is NULL. |
| TABLE_LOCK | VARCHAR2(8) | NO | This field is not supported. The default value of this field is NULL. |
| SAMPLE_SIZE | NUMBER | NO | This field is not supported. The default value of this field is NULL. |
| LAST_ANALYZED | DATE | NO | This field is not supported. The default value of this field is NULL. |
| PARTITIONED | VARCHAR2(3) | NO | Specifies whether the table is partitioned: |
| IOT_TYPE | VARCHAR2(12) | NO | This field is not supported. The default value of this field is NULL. |
| OBJECT_ID_TYPE | VARCHAR2(16) | NO | This field is not supported. The default value of this field is NULL. |
| TABLE_TYPE_OWNER | VARCHAR2(128) | NO | This field is not supported. The default value of this field is NULL. |
| TABLE_TYPE | VARCHAR2(128) | NO | This field is not supported. The default value of this field is NULL. |
| TEMPORARY | VARCHAR2(1) | NO | Specifies whether the table is a temporary table. |
| SECONDARY | VARCHAR2(1) | NO | This field is not supported. The default value of this field is NULL. |
| NESTED | VARCHAR2(3) | NO | Specifies whether the table is a nested table: |
| BUFFER_POOL | VARCHAR2(7) | NO | This field is not supported. The default value of this field is NULL. |
| FLASH_CACHE | VARCHAR2(7) | NO | This field is not supported. The default value of this field is NULL. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | This field is not supported. The default value of this field 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 field is not supported. The default value of this field is NULL. |
| USER_STATS | VARCHAR2(3) | NO | This field is not supported. The default value of this field is NULL. |
| DURATION | VARCHAR2(15) | NO | The duration of the temporary table. |
| SKIP_CORRUPT | VARCHAR2(8) | NO | This field is not supported. The default value of this field is NULL. |
| MONITORING | VARCHAR2(3) | NO | This field is not supported. The default value of this field is NULL. |
| CLUSTER_OWNER | VARCHAR2(30) | NO | This field is not supported. The default value of this field is NULL. |
| DEPENDENCIES | VARCHAR2(8) | NO | This field is not supported. The default value of this field is NULL. |
| COMPRESSION | VARCHAR2(8) | NO | This field is not supported. The default value of this field is NULL. |
| COMPRESS_FOR | VARCHAR2(12) | NO | This field is not supported. The default value of this field is NULL. |
| DROPPED | VARCHAR2(3) | NO | Specifies whether the table is in the recycle bin. |
| READ_ONLY | VARCHAR2(3) | NO | This field is not supported. The default value of this field is NULL. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | This field is not supported. The default value of this field is NULL. |
| RESULT_CACHE | VARCHAR2(7) | NO | This field is not supported. The default value of this field is NULL. |
Sample query
Query information from the T_SUBPART table.
obclient [SYS]> SELECT OWNER, TABLE_NAME, STATUS, PCT_FREE, NUM_ROWS, PARTITIONED, TEMPORARY, ROW_MOVEMENT, DROPPED, EXTERNAL FROM SYS.DBA_ALL_TABLES WHERE TABLE_NAME='T_SUBPART';
The query result is as follows:
+-------+------------+--------+----------+----------+-------------+-----------+--------------+---------+----------+
| OWNER | TABLE_NAME | STATUS | PCT_FREE | NUM_ROWS | PARTITIONED | TEMPORARY | ROW_MOVEMENT | DROPPED | EXTERNAL |
+-------+------------+--------+----------+----------+-------------+-----------+--------------+---------+----------+
| SYS | T_SUBPART | VALID | 0 | 1000 | YES | N | NO | NO | NO |
+-------+------------+--------+----------+----------+-------------+-----------+--------------+---------+----------+
1 row in set
References
Query all object tables and relational tables accessible to the current user: ALL_ALL_TABLES
USER_ALL_TABLES: view all tables and relationship tables owned by the current user.