Oracle教程 2023-04-04

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

本站中文解释

_SERVER

ALL_XSTREAM_OUTBOUND_SERVER是Oracle数据库中的一种视图，它提供了已经配置的XStream出站服务器的完整信息。用户可以使用它来获得服务器，如前缀，源端名称，源端版本，跟踪注释等的完整信息。

ALL_XSTREAM_OUTBOUND_SERVER视图可以在Oracle中使用如下SQL查询语句读取：

SELECT * FROM ALL_XSTREAM_OUTBOUND_SERVER;

该查询将返回所有的XStream出站服务器信息，比如源端名称，源端服务器版本，服务器前缀，注释以及启用状态等等。

官方英文解释

ALL_XSTREAM_OUTBOUND displays information about the XStream outbound servers accessible to the current user.

Related View

DBA_XSTREAM_OUTBOUND displays information about all XStream outbound servers in the database.

Column	Datatype	NULL	Description
`SERVER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the outbound server
`CONNECT_USER`	`VARCHAR2(128)`		Name of the user who can connect to the outbound server and process the outbound LCRs
`CAPTURE_NAME`	`VARCHAR2(128)`		Name of the Replication capture process
`SOURCE_DATABASE`	`VARCHAR2(128)`		Database where the transaction originated
`CAPTURE_USER`	`VARCHAR2(128)`		Current user who is enqueuing captured messages
`QUEUE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the queue associated with the outbound server
`QUEUE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the queue associated with the outbound server
`USER_COMMENT`	`VARCHAR2(4000)`		User comment
`CREATE_DATE`	`TIMESTAMP(6)`		Date when the outbound server was created
`STATUS`	`VARCHAR2(8)`		Status of the outbound server: `DISABLED` – The outbound server is not running. `DETACHED` – The outbound server is running, but the XStream client application is not attached to it. `ATTACHED` – The outbound server is running, and the XStream client application is attached to it. `ABORTED` – The outbound server became disabled because it encountered an error.
`COMMITTED_DATA_ONLY`	`VARCHAR2(3)`		`YES` if the outbound server can send only LCRs in committed transactions to the XStream client application. A committed transaction is an assembled, noninterleaving transaction with no rollbacks. `NO` if the outbound server can send LCRs in transactions that have not yet committed to the XStream client application. This mode is for internal Oracle use only.
`START_SCN`	`NUMBER`		The SCN from which the outbound server’s capture process started capturing changes when it was last started
`START_TIME`	`TIMESTAMP(6)`		The time from which the outbound server’s capture process started capturing changes when it was last started
`SOURCE_ROOT_NAME`	`VARCHAR2(128)`		The global name of the source root database
`LCRID_VERSION`	`NUMBER`		LCR ID format currently being used

本站中文解释

官方英文解释

相关推荐