ALL_APPLY_HANDLE_COLLISIONS

2.36 ALL_APPLY_HANDLE_COLLISIONS

ALL_APPLY_HANDLE_COLLISIONS provides details about apply handlers for collisions on objects visible to the user at the table level.

Related View

DBA_APPLY_HANDLE_COLLISIONS provides details about apply handlers for collisions at the table level.

Column	Datatype	NULL	Description
`APPLY_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the apply process
`OBJECT_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the target object
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the target object
`SOURCE_OBJECT_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Source database owner of the object
`SOURCE_OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Source database name of the object
`ENABLED`	`VARCHAR2(1)`	`NOT NULL`	State of the collision handlers: `Y` for enabled, `N` for disabled
`SET_BY`	`VARCHAR2(10)`		Entity that set up the handler: `USER` `GOLDENGATE`

Note:

This view is available starting with Oracle Database 12c Release 2 (12.2.0.1).