Static Data Dictionary Views, 6 of 666

ALL_APPLY_ERROR

ALL_APPLY_ERROR displays information about error transactions generated by the apply processes that dequeue events from queues accessible to the current user.

Related View

DBA_APPLY_ERROR displays information about error transactions generated by all apply processes in the database.

Column	Datatype	NULL	Description
`APPLY_NAME`	`VARCHAR2(30)`		Name of the apply process at the local database which processed the transaction
`QUEUE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue at the local database from which the transaction was dequeued
`QUEUE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the queue at the local database from which the transaction was dequeued
`LOCAL_TRANSACTION_ID`	`VARCHAR2(22)`		Local transaction ID for the error transaction
`SOURCE_DATABASE`	`VARCHAR2(128)`		Database where the transaction originated
`SOURCE_TRANSACTION_ID`	`VARCHAR2(22)`		Original transaction ID at the source database
`SOURCE_COMMIT_SCN`	`NUMBER`		Original commit system change number (SCN) for the transaction at the source database
`MESSAGE_NUMBER`	`NUMBER`		Identifier for the event in the transaction that raised an error
`ERROR_NUMBER`	`NUMBER`		Error number of the error raised by the transaction
`ERROR_MESSAGE`	`VARCHAR2(4000)`		Error message of the error raised by the transaction
`RECIPIENT_ID`	`NUMBER`		User ID of the original user that applied the transaction
`RECIPIENT_NAME`	`VARCHAR2(30)`		Name of the original user that applied the transaction
`MESSAGE_COUNT`	`NUMBER`		Total number of events inside the error transaction

See Also:

"DBA_APPLY_ERROR"