Note
This view is available starting with V2.2.30.
Purpose
This view displays all tables accessible to the current user.
Applicability
This view is available only in Oracle 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 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 and is currently set to NULL. |
| MAX_EXTENTS | NUMBER | NO | This column is not supported and is currently set to NULL. |
| PCT_INCREASE | NUMBER | NO | This column is not supported and is currently set to NULL. |
| FREELISTS | NUMBER | NO | This column is not supported and is currently set to NULL. |
| FREELIST_GROUPS | NUMBER | NO | This column is not supported and is currently set to NULL. |
| LOGGING | VARCHAR2(3) | NO | This column is not supported and is currently set to NULL. |
| BACKED_UP | VARCHAR2(1) | NO | This column is not supported and is currently set to NULL. |
| NUM_ROWS | NUMBER | NO | Number of rows in the table |
| BLOCKS | NUMBER | NO | This column is not supported and is currently set to NULL. |
| EMPTY_BLOCKS | NUMBER | NO | This column is not supported and is currently set to NULL. |
| AVG_SPACE | NUMBER | NO | This column is not supported and is currently set to NULL. |
| CHAIN_CNT | NUMBER | NO | This column is not supported and is currently set to NULL. |
| AVG_ROW_LEN | NUMBER | NO | This column is not supported and is currently set to NULL. |
| AVG_SPACE_FREELIST_BLOCKS | NUMBER | NO | This column is not supported and is currently set to NULL. |
| NUM_FREELIST_BLOCKS | NUMBER | NO | This column is not supported and is currently set to NULL. |
| DEGREE | VARCHAR2(10) | NO | This column is not supported and is currently set to NULL. |
| INSTANCES | VARCHAR2(10) | NO | This column is not supported. The default value is NULL. |
| CACHE | VARCHAR2(5) | 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 | Indicates whether the table is partitioned: |
| IOT_TYPE | VARCHAR2(12) | NO | This column is not supported. The default value is NULL. |
| TEMPORARY | VARCHAR2(1) | NO | Indicates 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 | Indicates 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 | This column is not supported. The default value is NULL. |
| 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 | Indicates 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(128) | 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(30) | 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. |
| CLUSTERING | VARCHAR2(3) | NO | The default value is NULL. |
| ACTIVITY_TRACKING | VARCHAR2(23) | NO | The default value is NULL. |
| DML_TIMESTAMP | VARCHAR2(25) | NO | The default value is NULL |
| HAS_IDENTITY | VARCHAR2(3) | NO | The default value is NULL |
| CONTAINER_DATA | VARCHAR2(3) | NO | The default value is NULL |
| INMEMORY | VARCHAR2(8) | NO | The default value is NULL |
| INMEMORY_PRIORITY | VARCHAR2(8) | NO | The default value is NULL |
| INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | This field is compatible with Oracle. It is NULL and has no practical meaning. |
| INMEMORY_COMPRESSION | VARCHAR2(17) | NO | This field is currently NULL by default. |
| INMEMORY_DUPLICATE | VARCHAR2(13) | NO | This field is currently NULL by default. |
| DEFAULT_COLLATION | VARCHAR2(100) | NO | This field is currently NULL by default. |
| DUPLICATED | VARCHAR2(1) | NO | This field is currently NULL by default. |
| SHARDED | VARCHAR2(1) | NO | This field is currently NULL by default. |
| EXTERNALLY_SHARDED | VARCHAR2(1) | NO | This field is currently NULL by default. |
| EXTERNALLY_DUPLICATED | VARCHAR2(1) | NO | This field is currently NULL by default. |
| EXTERNAL | VARCHAR2(3) | NO | Indicates whether the table is an external table: |
| HYBRID | VARCHAR2(3) | NO | This field is currently NULL by default. |
| CELLMEMORY | VARCHAR2(24) | NO | This field is compatible with Oracle. It is NULL and has no practical meaning. |
| CONTAINERS_DEFAULT | VARCHAR2(3) | NO | This field is currently NULL by default. |
| CONTAINER_MAP | VARCHAR2(3) | NO | This field is currently NULL by default. |
| EXTENDED_DATA_LINK | VARCHAR2(3) | NO | This field is currently NULL by default. |
| EXTENDED_DATA_LINK_MAP | VARCHAR2(3) | NO | This field is currently NULL by default. |
| INMEMORY_SERVICE | VARCHAR2(12) | NO | This field is currently NULL by default. |
| INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | This field is currently NULL by default. |
| CONTAINER_MAP_OBJECT | VARCHAR2(3) | NO | This field is currently NULL by default. |
| MEMOPTIMIZE_READ | VARCHAR2(8) | NO | This field is currently NULL by default. |
| MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | This field is currently NULL by default. |
| HAS_SENSITIVE_COLUMN | VARCHAR2(3) | NO | This column is NULL by default. |
| ADMIT_NULL | VARCHAR2(3) | NO | This column is NULL by default. |
| DATA_LINK_DML_ENABLED | VARCHAR2(3) | NO | This column is NULL by default |
| LOGICAL_REPLICATION | VARCHAR2(8) | NO | This column is NULL by default |
| AUTO_SPLIT | VARCHAR2(16) | NO | Indicates whether automatic partitioning is enabled for the table. Valid values:
NoteThis column is available starting with V4.3.4. |
| AUTO_SPLIT_TABLET_SIZE | VARCHAR2(128) | NO | Indicates the automatic partitioning threshold. When the value of the AUTO_SPLIT column is FALSE, the value of the AUTO_SPLIT_TABLET_SIZE column is 0.
NoteThis column is available starting with V4.3.4. |
Sample query
Query the information of the TBL1 table in the tables accessible to the current user.
obclient [SYS]> SELECT OWNER, TABLE_NAME, STATUS, PCT_FREE, TEMPORARY, NESTED, ROW_MOVEMENT, DROPPED, EXTERNAL FROM SYS.ALL_TABLES WHERE TABLE_NAME = 'TBL1';
The query result is as follows:
+-------+------------+--------+----------+-----------+--------+--------------+---------+----------+
| OWNER | TABLE_NAME | STATUS | PCT_FREE | TEMPORARY | NESTED | ROW_MOVEMENT | DROPPED | EXTERNAL |
+-------+------------+--------+----------+-----------+--------+--------------+---------+----------+
| SYS | TBL1 | VALID | 0 | N | NO | NO | NO | NO |
+-------+------------+--------+----------+-----------+--------+--------------+---------+----------+
1 row in set