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 is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TABLE_OWNER | VARCHAR2(128) | NO | The user who modified the table. |
| 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 modified the last time. |
| 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 deleted since the last analysis. |