Feature
USER_TAB_MODIFICATIONS provides the modification history of tables owned by the current user since the table statistics were collected the last time.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| 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. |