4.112 ALL_TAB_MODIFICATIONS
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: