Purpose
The DBA_TAB_MODIFICATIONS view displays the modification history of all tables of the database since the table statistics were collected the last time.
Note
This view was introduced in OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_OWNER | VARCHAR2(128) | NO | The database to which the modified table belongs. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the modified table. |
| PARTITION_NAME | VARCHAR2(128) | NO | The name of the modified partition. |
| SUBPARTITION_NAME | VARCHAR2(128) | NO | The name of the modified subpartition. |
| INSERTS | NUMBER | NO | The approximate number of insertions since the last statistic collection operation. |
| UPDATES | NUMBER | NO | The approximate number of updates since the last statistic collection operation. |
| DELETES | NUMBER | NO | The approximate number of deletions since the last statistic collection operation. |
| TIMESTAMP | DATE | NO | The time when the table was last modified. |
| TRUNCATED | VARCHAR2(3) | NO | Indicates whether the table has been truncated since the last analysis. |
| DROP_SEGMENTS | NUMBER | NO | The number of partition and subpartition segments that have been dropped since the last analysis. |