Note
This view is available starting with V2.2.30.
Purpose
This view displays all object tables and relational tables in the current tenant. The columns of this view are the same as those of ALL_ALL_TABLES.
Applicability
This view is available only in 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 column is not supported. The default value of this column is NULL. |
| IOT_NAME | VARCHAR2(128) | NO | This column is not supported. The default value of this column 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 of this column is NULL. |
| INI_TRANS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| MAX_TRANS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| INITIAL_EXTENT | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| NEXT_EXTENT | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| MIN_EXTENTS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| MAX_EXTENTS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| PCT_INCREASE | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| FREELISTS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| FREELIST_GROUPS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| LOGGING | VARCHAR2(3) | NO | This column is not supported. The default value of this column is NULL. |
| BACKED_UP | VARCHAR2(1) | NO | This column is not supported. The default value of this column is NULL. |
| NUM_ROWS | NUMBER | NO | The number of rows in the table |
| BLOCKS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| EMPTY_BLOCKS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| AVG_SPACE | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| CHAIN_CNT | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| AVG_ROW_LEN | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| NUM_FREELIST_BLOCKS | NUMBER | NO | This column is not supported. The default value of this column is NULL. |
| DEGREE | VARCHAR2(40) | NO | This column is not supported. The default value of this column is NULL. |
| INSTANCES | VARCHAR2(40) | NO | This column is not supported and defaults to NULL. |
| CACHE | VARCHAR2(20) | NO | This column is not supported and defaults to NULL. |
| TABLE_LOCK | VARCHAR2(8) | NO | This column is not supported and defaults to NULL. |
| SAMPLE_SIZE | NUMBER | NO | This column is not supported and defaults to NULL. |
| LAST_ANALYZED | DATE | NO | This column is not supported and defaults to NULL. |
| PARTITIONED | VARCHAR2(3) | NO | Indicates whether the table is partitioned:
|
| IOT_TYPE | VARCHAR2(12) | NO | This column is not supported and defaults to NULL. |
| OBJECT_ID_TYPE | VARCHAR2(16) | NO | This column is not supported and defaults to NULL. |
| TABLE_TYPE_OWNER | VARCHAR2(128) | NO | This column is not supported and defaults to NULL. |
| TABLE_TYPE | VARCHAR2(128) | NO | This column is not supported and defaults to NULL. |
| TEMPORARY | VARCHAR2(1) | NO | Indicates whether the table is a temporary table. |
| SECONDARY | VARCHAR2(1) | NO | This column is not supported and defaults to NULL. |
| NESTED | VARCHAR2(3) | NO | Indicates whether the table is a nested table:
|
| BUFFER_POOL | VARCHAR2(7) | NO | This column is not supported and defaults to NULL. |
| FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported and defaults to NULL. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported and defaults to NULL. |
| ROW_MOVEMENT | VARCHAR2(8) | NO | This column is not supported and defaults to NULL. |
| GLOBAL_STATS | VARCHAR2(3) | NO | This column is not supported and defaults to NULL. |
| USER_STATS | VARCHAR2(3) | NO | This column is not supported and defaults to NULL. |
| DURATION | VARCHAR2(15) | NO | Indicates the duration of the temporary table. |
| SKIP_CORRUPT | VARCHAR2(8) | NO | This column is not supported and defaults to NULL. |
| MONITORING | VARCHAR2(3) | NO | This column is not supported and defaults to NULL. |
| CLUSTER_OWNER | VARCHAR2(30) | NO | This column is not supported and defaults to NULL. |
| DEPENDENCIES | VARCHAR2(8) | NO | This column is not supported and defaults to NULL. |
| COMPRESSION | VARCHAR2(8) | NO | This column is not supported and defaults to NULL. |
| COMPRESS_FOR | VARCHAR2(12) | NO | This column is not supported and defaults to 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 and defaults to NULL. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | This column is not supported and defaults to NULL. |
| RESULT_CACHE | VARCHAR2(7) | NO | This column is not supported and defaults to NULL. |
Sample query
Query 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 relationship tables accessible to the current user: ALL_ALL_TABLES
Query all object tables and relationship tables owned by the current user: USER_ALL_TABLES