Oracle教程 2023-03-25

Oracle 视图 ALL_APPLY_REPERROR_HANDLERS 官方解释，作用，如何使用详细说明

ALL_APPLY_REPERROR_HANDLERS视图用于查看当前用户的所有Streams Apply进程的错误处理过程。ALL_APPLY_REPERROR_HANDLERS视图具有如下内容：

APPLY_NAME：应用程序进程的名称。

APPLY_HANDLER_FUNC：处理错误的函数。

APPLY_HANDLER_PARAMS：传递给函数的参数。

使用ALL_APPLY_REPERROR_HANDLERS视图，可以查询当前用户的所有Streams Apply进程的错误处理过程：

SELECT apply_name, apply_handler_func, apply_handler_params
FROM all_apply_reperror_handlers;

ALL_APPLY_REPERROR_HANDLERS provides details about apply reperror handlers on objects visible to the user.

Related View

DBA_APPLY_REPERROR_HANDLERS provides details about apply reperror handlers.

Column	Datatype	NULL	Description
`APPLY_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the apply process
`OBJECT_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object
`OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object
`SOURCE_OBJECT_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Source database owner of the source object
`SOURCE_OBJECT_NAME`	`VARCHAR2(128)`	`NOT NULL`	Source database name of the object
`ERROR_NUMBER`	`NUMBER`	`NOT NULL`	Error number for the handler
`METHOD`	`VARCHAR2(18)`		Error handling method: `ABEND` `RECORD` `IGNORE` `RETRY` `RETRY_TRANSACTION` `RECORD_TRANSACTION`
`MAX_RETRIES`	`NUMBER`		Maximum number of times to retry for the method `RETRY` and `RETRY_TRANSACTION`
`DELAY_CSECS`	`NUMBER`		Number of centiseconds to wait between retries for `RETRY` and `RETRY_TRANSACTION`
`SET_BY`	`VARCHAR2(10)`		Entity that set up the handler: `USER` `GOLDENGATE`