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_APPLY_DML_CONF_HANDLERS

Object Details

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

Details about dml conflict handlers on objects visible to the current user

[View Source]

Columns

Name	Datatype	Length	Comments
APPLY_NAME	VARCHAR2	(128)	Name of the apply process
OBJECT_OWNER	VARCHAR2	(128)	Owner of the target object
OBJECT_NAME	VARCHAR2	(128)	Name of the target object
SOURCE_OBJECT_OWNER	VARCHAR2	(128)	Owner of the source object
SOURCE_OBJECT_NAME	VARCHAR2	(128)	Name of the source object
COMMAND_TYPE	VARCHAR2	(6)	Type of the DML operation
CONFLICT_TYPE	VARCHAR2	(11)	Description of the conflict
METHOD_NAME	VARCHAR2	(9)	Description of the conflict handling method
CONFLICT_HANDLER_NAME	VARCHAR2	(30)	Name of the conflict handler
RESOLUTION_COLUMN	VARCHAR2	(30)	Name of the resolution column
SET_BY	VARCHAR2	(10)	Entity that set up the handler: USER, GOLDENGATE

Query Text

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


SELECT APPLY_NAME
,      OBJECT_OWNER
,      OBJECT_NAME
,      SOURCE_OBJECT_OWNER
,      SOURCE_OBJECT_NAME
,      COMMAND_TYPE
,      CONFLICT_TYPE
,      METHOD_NAME
,      CONFLICT_HANDLER_NAME
,      RESOLUTION_COLUMN
,      SET_BY
FROM SYS.ALL_APPLY_DML_CONF_HANDLERS;

Dependencies

[top of page]

SYS.ALL_APPLY_DML_CONF_HANDLERS references the following:

SYS: ALL_APPLY; ALL_TABLES; DBA_APPLY_DML_CONF_HANDLERS

SYS.ALL_APPLY_DML_CONF_HANDLERS is referenced by following:

PUBLIC: ALL_APPLY_DML_CONF_HANDLERS
SYS: ALL_APPLY_DML_CONF_COLUMNS