eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_TAB_MODIFICATIONS

Object Details

Object Name:	ALL_TAB_MODIFICATIONS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Information regarding modifications to tables

[View Source]

Columns

Name	Datatype	Length	Comments
TABLE_OWNER	VARCHAR2	(128)	Owner of modified table
TABLE_NAME	VARCHAR2	(128)	Modified table
PARTITION_NAME	VARCHAR2	(128)	Modified partition
SUBPARTITION_NAME	VARCHAR2	(128)	Modified subpartition
INSERTS	NUMBER		Approximate number of rows inserted since last analyze
UPDATES	NUMBER		Approximate number of rows updated since last analyze
DELETES	NUMBER		Approximate number of rows deleted since last analyze
TIMESTAMP	DATE		Timestamp of last time this row was modified
TRUNCATED	VARCHAR2	(3)	Was this object truncated since the last analyze?
DROP_SEGMENTS	NUMBER		Number of (sub)partition segment dropped since the last analyze?

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TABLE_OWNER
,      TABLE_NAME
,      PARTITION_NAME
,      SUBPARTITION_NAME
,      INSERTS
,      UPDATES
,      DELETES
,      TIMESTAMP
,      TRUNCATED
,      DROP_SEGMENTS
FROM SYS.ALL_TAB_MODIFICATIONS;

Dependencies

[top of page]

SYS.ALL_TAB_MODIFICATIONS references the following:

SYS: MON_MODS_ALL$; OBJ$; OBJAUTH$; TAB$; TABSUBPART$; USER$

SYS.ALL_TAB_MODIFICATIONS is referenced by following:

PUBLIC: ALL_TAB_MODIFICATIONS