Note
This view is available starting with V2.2.30.
Purpose
You can query the object tables and relationship tables that a user can access. Unlike ALL_TABLES, ALL_ALL_TABLES can query object tables.
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 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 free space percentage of 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 | 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. |
Sample query
Query the information about the T_SUBPART table in the object and relational tables that the user can access.
obclient [SYS]> SELECT OWNER, TABLE_NAME, STATUS, PCT_FREE, NUM_ROWS, PARTITIONED, TEMPORARY, ROW_MOVEMENT, DROPPED, EXTERNAL FROM SYS.ALL_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 and relational tables in the current tenant: DBA_ALL_TABLES
View all object and relational tables owned by the current user: USER_ALL_TABLES