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 in this view are the same as those in ALL_ALL_TABLES.
Applicability
This view is available only in OceanBase Database in Oracle mode.
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 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(40) | NO | This column is not supported. The value of this column is NULL by default. |
| INSTANCES | VARCHAR2(40) | NO | This column is not supported and is NULL by default. |
| CACHE | VARCHAR2(20) | NO | This column is not supported and is NULL by default. |
| TABLE_LOCK | VARCHAR2(8) | NO | This column is not supported and is NULL by default. |
| SAMPLE_SIZE | NUMBER | NO | This column is not supported and is NULL by default. |
| LAST_ANALYZED | DATE | NO | This column is not supported and is NULL by default. |
| PARTITIONED | VARCHAR2(3) | NO | Indicates whether the table is partitioned:
|
| IOT_TYPE | VARCHAR2(12) | NO | This column is not supported and is NULL by default. |
| OBJECT_ID_TYPE | VARCHAR2(16) | NO | This column is not supported and is NULL by default. |
| TABLE_TYPE_OWNER | VARCHAR2(128) | NO | This column is not supported and is NULL by default. |
| TABLE_TYPE | VARCHAR2(128) | NO | This column is not supported and 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 and is NULL by default. |
| NESTED | VARCHAR2(3) | NO | Indicates whether the table is a nested table:
|
| BUFFER_POOL | VARCHAR2(7) | NO | This column is not supported and is NULL by default. |
| FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported and is NULL by default. |
| CELL_FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported and is NULL by default. |
| ROW_MOVEMENT | VARCHAR2(8) | NO | This column is not supported and is NULL by default. |
| GLOBAL_STATS | VARCHAR2(3) | NO | This column is not supported and is NULL by default. |
| USER_STATS | VARCHAR2(3) | NO | This column is not supported and 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 and is NULL by default. |
| MONITORING | VARCHAR2(3) | NO | This column is not supported and is NULL by default. |
| CLUSTER_OWNER | VARCHAR2(30) | NO | This column is not supported and is NULL by default. |
| DEPENDENCIES | VARCHAR2(8) | NO | This column is not supported and is NULL by default. |
| COMPRESSION | VARCHAR2(8) | NO | This column is not supported and is NULL by default. |
| COMPRESS_FOR | VARCHAR2(12) | NO | This column is not supported and 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 and is NULL by default. |
| SEGMENT_CREATED | VARCHAR2(3) | NO | This column is not supported and is NULL by default. |
| RESULT_CACHE | VARCHAR2(7) | NO | This column is not supported and is NULL by default. |
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
View all object tables and relationship tables accessible to the current user: ALL_ALL_TABLES
View all object tables and relationship tables owned by the current user: USER_ALL_TABLES