DBA_TABLES

Purpose

This view displays all tables in the database.

Columns

              |

| 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(10) | NO | This column is not supported. The default value of this column is NULL. | | INSTANCES | VARCHAR2(10) | NO | This column is not supported. The default value of this column is NULL. | | CACHE

      | VARCHAR2(5)    | 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:

• YES
• NO

• YES
• NO

| AR2(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 | This column is compatible with Oracle. The value is NULL and has no practical meaning. | | INMEMORY_PRIORITY | VARCHAR2(8) | NO | This column is compatible with Oracle. The value is NULL and has no practical meaning. | | INMEMORY_DISTRIBUTE | VARCHAR2(15) | NO | This column is compatible with Oracle. The value is NULL and has no practical meaning. | | INMEMORY_COMPR

| ESSION | VARCHAR2(17) | NO | This column is compatible with Oracle. The value is NULL, which has no actual meaning. | | INMEMORY_DUPLICATE | VARCHAR2(13) | NO | This column is compatible with Oracle. The value is NULL, which has no actual meaning. | | DEFAULT_COLLATION | VARCHAR2(100) | NO | The default value of this column is NULL. | | DUPLICATED | VARCHAR2(1) | NO | The default value of this column is NULL. | | SHARDED | VARCHAR2(1) | NO | The default value of this column is NULL. | | EXTERNALLY_SHARDED | VARCHAR2(1) | NO | The default value of this column is NULL. | | EXTERNALLY_DUPLICATED | VARCHAR2(1) | NO | The default value of this column is NULL. | | EXTERNAL | VARCHAR2(3) | NO | Indicates whether the table is an external table. Valid values: YES and NO. | | HYBRID | VARCHAR2(3) | NO | The default value of this column is NULL. | | CELLMEMORY | VARCHAR2(24) | NO | This column is compatible with Oracle. The value is NULL, which has no actual meaning. | | CONTAINERS_DEFAULT | VARCHAR2(3) | NO | The default value of this column is NULL| | CONTAINER_MAP | VARCHAR2(3) | NO | The default value of this column is NULL | | EXTENDED_DATA_LINK | VARCHAR2(3) | NO | The default value of this column is NULL. | | EXTENDED_DATA_LINK_MAP | VARCHAR2(3) | NO | The default value of this column is NULL. | | INMEMORY_SERVICE | VARCHAR2(12) | NO | This column is compatible with Oracle. The value is NULL, which has no actual meaning. | | INMEMORY_SERVICE_NAME | VARCHAR2(1000) | NO | This column is compatible with Oracle. The value is NULL, which has no actual meaning. | | CONTAINER_MAP_OBJECT | VARCHAR2(3) | NO | The default value of this column is NULL | | MEMOPTIMIZE_READ | VARCHAR2(8) | NO | The default value of this column is NULL. | | MEMOPTIMIZE_WRITE | VARCHAR2(8) | NO | The default value of this column is NULL. | | HAS_SENSITIVE_C

OLUMN | 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:

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

Sample query

Query the information of the TBL2_F_RL table in the database.

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

The query result is as follows:

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

References

• CDB_TABLES

• ALL_TABLES

• USER_TABLES