USER_TABLES

Purpose

This view displays all tables owned by the current user.

Columns

NO | This column is not supported. It is set to NULL by default. | | PCT_INCREASE | NUMBER | NO | This column is not supported. It is set to NULL by default. | | FREELISTS | NUMBER | NO | This column is not supported. It is set to NULL by default. | | FREELIST_GROUPS | NUMBER | NO | This column is not supported. It is set to NULL by default. | | LOGGING | VARCHAR2(3) | NO | This column is not supported. It is set to NULL by default. | | BACKED_UP | VARCHAR2(1) | NO | This column is not supported. It is set to NULL by default. | | NUM_ROWS | NUMBER | NO | The number of rows in the table. | | BLOCKS | NUMBER | NO | This column is not supported. It is set to NULL by default. | | EMPTY_BLOCKS | NUMBER | NO | This column is not supported. It is set to NULL by default. | | AVG_SPACE | NUMBER | NO | This column is not supported. It is set to NULL by default. | | CHAIN_CNT | NUMBER | NO | This column is not supported. It is set to NULL by default. | | AVG_ROW_LEN | NUMBER | NO | This column is not supported. It is set to NULL by default. | | AVG_SPACE_FREELIST_BLOCKS | NUMBER | NO | This column is not supported. It is set to NULL by default. | | NUM_FREELIST_BLOCKS | NUMBER | NO | This column is not supported. It is set to NULL by default. | | DEGREE | VARCHAR2(10) | NO | This column is not supported. It is set to NULL by default. | | INSTANCES | VARCHAR2(10) | NO | This column is not supported. It is set to NULL by default. | | CACHE | VARCH

AR2(5) | NO | This column is not supported. The default value of this column is NULL. | | TABLE_LOCK | VARCHAR2(8) | NO | This column is not supported. The default value of this column is NULL. | | SAMPLE_SIZE | NUMBER | NO | This column is not supported. The default value of this column is NULL. | | LAST_ANALYZED | DATE | NO | This column is not supported. The default value of this column is NULL. | | PARTITIONED | VARCHAR2(3) | NO | This column is not supported. The default value of this column is NULL. | | IOT_TYPE | VARCHAR2(12) | NO | This column is not supported. The default value of this column 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 of this column is NULL. | | NESTED | VARCHAR2(3) | NO | This column is not supported. The default value of this column is NULL. | | BUFFER_POOL | VARCHAR2(7) | NO | This column is not supported. The default value of this column is NULL. | | FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported. The default value of this column is NULL. | | CELL_FLASH_CACHE | VARCHAR2(7) | NO | This column is not supported. The default value of this column is NULL. | | ROW_MOVEMENT | VARCHAR2(8) | NO | This column is not supported. The default value of this column is NULL. | | GLOBAL_STATS | VARCHAR2(3) | NO | This column is not supported. The default value of this column is NULL. | | USER_STATS | VARCHAR2(3) | NO | This column is not supported. The default value of this column is NULL. | | DURATION | VARCHAR2(15) | NO | Indicates the duration of the temporary table. | | SKIP_CORRUPT

| VARCHAR2(8) | NO | This column is not supported. It is NULL by default. | | MONITORING | VARCHAR2(3) | NO | This column is not supported. It is NULL by default. | | CLUSTER_OWNER | VARCHAR2(128) | NO | This column is not supported. It is NULL by default. | | DEPENDENCIES | VARCHAR2(8) | NO | This column is not supported. It is NULL by default. | | COMPRESSION | VARCHAR2(8) | NO | This column is not supported. It is NULL by default. | | COMPRESS_FOR | VARCHAR2(30) | NO | This column is not supported. It 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. It is NULL by default. | | SEGMENT_CREATED | VARCHAR2(3) | NO | This column is not supported. It is NULL by default. | | RESULT_CACHE | VARCHAR2(7) | NO | This column is not supported. It is NULL by default. | | CLUSTERING | VARCHAR2(3) | NO | This column is NULL by default. | | ACTIVITY_TRACKING | VARCHAR2(23) | NO | This column is NULL by default. | | DML_TIMESTAMP | VARCHAR2(25) | NO | This column is NULL by default. | | HAS_IDENTITY | VARCHAR2(3) | NO | This column is NULL by default. | | CONTAINER_DATA | VARCHAR2(3) | NO | This column is NULL by default. | | INMEMORY | VARCHAR2(8) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. | | INMEMORY_PRIORITY | VARCHAR2(8) | NO | This column is compatible with Oracle. Its value is NULL and has no practical meaning. | | INMEMORY_DISTRIBUTE | VARCHAR2(

15. | NO | This field is compatible with Oracle. The value is NULL and has no practical meaning. | | INMEMORY_COMPRESSION | VARCHAR2(17) | NO | This field is compatible with Oracle. The value is NULL and has no practical meaning. | | INMEMORY_DUPLICATE | VARCHAR2(13) | NO | This field is compatible with Oracle. The value is NULL and has no practical meaning. | | DEFAULT_COLLATION | VARCHAR2(100) | NO | This field is currently set to NULL by default. | | DUPLICATED | VARCHAR2(1) | NO | This field is currently set to NULL by default. | | SHARDED | VARCHAR2(1) | NO | This field is currently set to NULL by default. | | EXTERNALLY_SHARDED | VARCHAR2(1) | NO | This field is currently set to NULL by default. | | EXTERNALLY_DUPLICATED | VARCHAR2(1) | NO | This field is currently set to NULL by default. | | EXTERNAL | VARCHAR2(3) | NO | Indicates whether the table is an external table:

16. YES
17. NO | | HYBRID | VARCHAR2(3) | NO | This field is currently set to NULL by default. | | CELLMEMORY | VARCHAR2(24) | NO | This field is compatible with Oracle. The value is NULL and has no practical meaning. | | CONTAINERS_DEFAULT | VARCHAR2(3) | NO | This field is currently set to NULL by default. | | CONTAINER_MAP | VARCHAR2(3) | NO | This field is currently set to NULL by default. | | EXTENDED_DATA_LINK | VARCHAR2(3) | NO | This field is currently set to NULL by default. | | EXTENDED_DATA_LINK_MAP | VARCHAR2(3) | NO | This field is currently set to NULL by default. | | INMEMORY_SERVICE | VARCHAR2(12) | NO | This field is compatible with Oracle. The value is NULL and has no practical meaning. | | INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | This field is compatible with Oracle. The value is NULL and has no practical meaning. | | CONTAINER_MAP_OBJECT | VARCHAR2(3) | NO | This field is currently set to NULL by default. | | MEMOPTIMIZE_READ | VARCHAR2(8) | NO | This field is currently set to NULL by default. | | MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO

    | This column is set to NULL by default. | | HAS_SENSITIVE_COLUMN | VARCHAR2(3) | NO | This column is set to NULL by default. | | ADMIT_NULL | VARCHAR2(3) | NO | This column is set to NULL by default. | | DATA_LINK_DML_ENABLED | VARCHAR2(3) | NO | This column is set to NULL by default. | | LOGICAL_REPLICATION | VARCHAR2(8) | NO | This column is set to NULL by default. | | AUTO_SPLIT | VARCHAR2(16) | NO | Indicates whether automatic partitioning is enabled for the table. Valid values:

    • FALSE (default): Automatic partitioning is disabled for the table.
    • TRUE: Automatic partitioning is enabled for the table.

    Note

    This column is available starting with V4.3.4.

    | | AUTO_SPLIT_TABLET_SIZE | VARCHAR2(128) | NO | Indicates the threshold for automatic partition splitting. When the value of the AUTO_SPLIT column is FALSE, the value of the AUTO_SPLIT_TABLET_SIZE column is 0.

    Note

    This column is available starting with V4.3.4.

    |

Sample query

Query the information about the TBL1 table in the tables owned by the current user.

obclient [SYS]> SELECT TABLE_NAME, STATUS, PCT_FREE, TEMPORARY, NESTED, ROW_MOVEMENT, DROPPED, EXTERNAL FROM SYS.USER_TABLES WHERE TABLE_NAME = 'TBL1';

The query result is as follows:

+------------+--------+----------+-----------+--------+--------------+---------+----------+
| TABLE_NAME | STATUS | PCT_FREE | TEMPORARY | NESTED | ROW_MOVEMENT | DROPPED | EXTERNAL |
+------------+--------+----------+-----------+--------+--------------+---------+----------+
| TBL1       | VALID  |        0 | N         | NO     | NO           | NO      | NO       |
+------------+--------+----------+-----------+--------+--------------+---------+----------+
1 row in set

References

• ALL_TABLES

• DBA_TABLES