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_SUMDELTA

Object Details

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

Direct path load entries accessible to the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TABLEOBJ#	NUMBER		Yes	Object number of the table
PARTITIONOBJ#	NUMBER		Yes	Object number of table partitions (if the table is partitioned)
DMLOPERATION	VARCHAR2	(1)		Type of DML operation applied to the table
SCN	NUMBER		Yes	SCN when the bulk DML occurred
TIMESTAMP	DATE		Yes	Timestamp of log entry
LOWROWID	ROWID	(10)	Yes	The start ROWID in the loaded rowid range
HIGHROWID	ROWID	(10)	Yes	The end ROWID in the loaded rowid range
SEQUENCE	NUMBER			The sequence# of the direct load
XID	NUMBER			The transaction ID of the direct load

Query Text

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


SELECT TABLEOBJ#
,      PARTITIONOBJ#
,      DMLOPERATION
,      SCN
,      TIMESTAMP
,      LOWROWID
,      HIGHROWID
,      SEQUENCE
,      XID
FROM SYS.ALL_SUMDELTA;

Dependencies

[top of page]

SYS.ALL_SUMDELTA references the following:

SYS: OBJ$; OBJAUTH$; SUMDELTA$; USER$

SYS.ALL_SUMDELTA is referenced by following:

PUBLIC: ALL_SUMDELTA