ALL_APPLY_DML_CONF_HANDLERS

Previous Next JavaScript must be enabled to correctly display this content

2.31 ALL_APPLY_DML_CONF_HANDLERS

ALL_APPLY_DML_CONF_HANDLERS provides details about DML conflict handlers on objects visible to the current user.

Related View

DBA_APPLY_DML_CONF_HANDLERS provides details about DML conflict handlers.

Column	Datatype	NULL	Description
`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)`		Source database owner of the object
`SOURCE_OBJECT_NAME`	`VARCHAR2(128)`		Source database name of the object
`COMMAND_TYPE`	`VARCHAR2(6)`		Type of the DML operation: `INSERT`, `UPDATE`, or `DELETE`
`CONFLICT_TYPE`	`VARCHAR2(11)`		Type of conflict: `ROW EXISTS` `ROW MISSING`
`METHOD_NAME`	`VARCHAR2(9)`		Method used for resolving the error, depending on the conflict type: `OVERWRITE` `RECORD` `IGNORE` `MAXIMUM` `MINIMUM` `DELTA`
`CONFLICT_HANDLER_NAME`	`VARCHAR2(128)`		Name of the conflict handler
`RESOLUTION_COLUMN`	`VARCHAR2(128)`		Name of the column used to resolve the conflict for `MAXIMUM`, `MINIMUM`, and `DELTA`
`SET_BY`	`VARCHAR2(10)`		Entity that set up the handler: `USER` `GOLDENGATE`

See Also:

"DBA_APPLY_DML_CONF_HANDLERS"