Oracle 视图 ALL_TAB_MODIFICATIONS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_TAB_MODIFICATIONS 属于 Oracle Data Dictionary 视图，它储存了每张表被编辑过的操作信息，包括 DDL（数据定义语言）和 DML（数据操纵语言）操作，例如表的创建、更改、修改、删除等行为。它可以根据用户指定的参数信息来查询指定的表的变更信息。
使用方法:
语法：
SELECT * FROM ALL_TAB_MODIFICATIONS WHERE TABLE_NAME = ‘表名’
在我们想查看某张表的变更信息时，可以使用 ALL_TAB_MODIFICATIONS 视图查询结果，本质是运行SQL语句查询相应表的变更历史信息，可以获取到更新和删除前后的数据，查询结果包括TABLE_NAME（表名），OPERATION（操作类型），TIMESTAMP（变更时间），USERNAME（操作用户），CTIME（创建时间）等信息。
官方英文解释
ALL_TAB_MODIFICATIONS describes tables accessible to the current user that have been modified since the last time statistics were gathered on the tables.
Related Views
DBA_TAB_MODIFICATIONSdescribes such information for all tables in the database.USER_TAB_MODIFICATIONSdescribes such information for tables owned by the current user. This view does not display theTABLE_OWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
| Owner of the modified table | |
|
| Name of the modified table | |
|
| Name of the modified partition | |
|
| Name of the modified subpartition | |
|
| Approximate number of inserts since the last time statistics were gathered | |
|
| Approximate number of updates since the last time statistics were gathered | |
|
| Approximate number of deletes since the last time statistics were gathered | |
|
| Indicates the last time the table was modified | |
|
| Indicates whether the table has been truncated since the last analyze ( | |
|
| Number of partition and subpartition segments dropped since the last analyze |
See Also:
“DBA_TAB_MODIFICATIONS”
“USER_TAB_MODIFICATIONS”
编辑：广州明生医药有限公司
标签：信息,操作,视图,数据,查询结果