Oracle教程 2023-02-23

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

本站中文解释

_SOURCE视图

ALL_APPLY_SOURCE视图是Oracle数据库中的一个系统视图，可以用来显示和检索数据变更任务的源代码。该视图包含以下列：APPLY_NAME，SOURCE_LINE_NUMBER，TEXT（源码），CREATION_DATE（创建日期），LAST_CHANGE_DATE（最后修改日期）等。

使用ALL_APPLY_SOURCE视图，可以在Oracle中获取一个特定数据变更任务的具体信息，例如：可以查看该任务的源代码，创建和修改日期等。

步骤：

1.使用以下SQL语句创建一个Oracle视图：

CREATE OR REPLACE VIEW ALL_APPLY_SOURCE AS

SELECT apply_name, source_line_number, text, creation_date,last_change_date

FROM dba_apply_source;

2.使用以下SQL语句查看ALL_APPLY_SOURCE视图：

SELECT * FROM ALL_APPLY_SOURCE;

3.使用以下SQL语句查看指定数据变更任务的详细内容：

SELECT * FROM ALL_APPLY_SOURCE

WHERE apply_name = ‘task_name’

ORDER BY source_line_number;

官方英文解释

ALL_APPLY displays information about the apply processes that dequeue messages from queues accessible to the current user.

Related View

DBA_APPLY displays information about all apply processes in the database.

Column	Datatype	NULL	Description
`APPLY_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the apply process
`QUEUE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the queue from which the apply process dequeues
`QUEUE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the queue from which the apply process dequeues
`APPLY_CAPTURED`	`VARCHAR2(3)`		Indicates whether the apply process applies captured messages (`YES`) or user-enqueued messages (`NO`)
`RULE_SET_NAME`	`VARCHAR2(128)`		Name of the positive rule set used by the apply process for filtering
`RULE_SET_OWNER`	`VARCHAR2(128)`		Owner of the positive rule set used by the apply process for filtering
`APPLY_USER`	`VARCHAR2(128)`		User who is applying messages
`APPLY_DATABASE_LINK`	`VARCHAR2(128)`		Database link to which changes are applied. If NULL, then changes are applied to the local database.
`APPLY_TAG`	`RAW(2000)`		Tag associated with redo log records that are generated when changes are made by the apply process
`DDL_HANDLER`	`VARCHAR2(98)`		Name of the user-specified data definition language (DDL) handler, which handles DDL logical change records (LCRs)
`PRECOMMIT_HANDLER`	`VARCHAR2(98)`		Name of the user-specified pre-commit handler
`MESSAGE_HANDLER`	`VARCHAR2(98)`		Name of the user-specified procedure that handles dequeued messages other than logical change records (LCRs)
`STATUS`	`VARCHAR2(8)`		Status of the apply process: `DISABLED` `ENABLED` `ABORTED`
`MAX_APPLIED_MESSAGE_NUMBER`	`NUMBER`		System change number (SCN) corresponding to the apply process high watermark for the last time the apply process was stopped using the `DBMS_APPLY_ADM.STOP_APPLY` procedure with the `force` parameter set to `false`. The apply process high watermark is the SCN beyond which no messages have been applied.
`NEGATIVE_RULE_SET_NAME`	`VARCHAR2(128)`		Name of the negative rule set used by the apply process for filtering
`NEGATIVE_RULE_SET_OWNER`	`VARCHAR2(128)`		Owner of the negative rule set used by the apply process for filtering
`STATUS_CHANGE_TIME`	`DATE`		Time that the `STATUS` of the apply process was changed
`ERROR_NUMBER`	`NUMBER`		Error number if the apply process was aborted
`ERROR_MESSAGE`	`VARCHAR2(4000)`		Error message if the apply process was aborted
`MESSAGE_DELIVERY_MODE`	`VARCHAR2(10)`		Reserved for internal use
`PURPOSE`	`VARCHAR2(19)`		Purpose of the apply process: `GoldenGate Apply` – An Oracle GoldenGate Inbound server configured by Oracle GoldenGate integrated replicat `XStream` `Out` – An XStream outbound server in an XStream Out configuration `XStream` `In` – An XStream inbound server in an XStream In configuration `AUDIT` `VAULT` – An apply process in an audit vault configuration `CHANGE` `DATA` `CAPTURE` – An apply process in a change data capture configuration
`LCRID_VERSION`	`NUMBER`		LCR ID format currently being used

本站中文解释

官方英文解释

相关推荐