Oracle教程

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

本站中文解释

ALL_XSTREAM_OUT_SUPPORT_MODE是一个Oracle视图，它包含节点以及参数以确定节点是否支持XStream出站传输。它列出了每个节点是否支持XStream Outbound传输，该传输方式用于从分布式网络中的一个节点向另一个节点发送消息。

该视图包含以下列：

`NODE_NAME`：定义节点的名称。
`SUPPORTED_MODE`：定义节点是否支持XStream Outbound传输。

该视图通常用于设置本地节点，以便连接到另一个节点并发送XML文档。为了使用该视图，必须安装Oracle Streams并将其初始化。有关更多信息，请参阅Oracle文档。

要从ALL_XSTREAM_OUT_SUPPORT_MODE视图中获取特定节点的支持模式，请使用SELECT语句，如下所示：

SELECT SUPPORTED_MODE FROM ALL_XSTREAM_OUT_SUPPORT_MODE
WHERE NODE_NAME = ‘SpecificNode’;

上面显示的SELECT语句将返回指定节点是否支持XStream Outbound传输的信息。

官方英文解释

ALL_XSTREAM_OUT_SUPPORT_MODE displays information about the level of XStream capture process support for the tables accessible to the current user in the database.

Related View

DBA_XSTREAM_OUT_SUPPORT_MODE displays information about the level of XStream capture process support for the tables in the database.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Table owner

OBJECT_NAME

VARCHAR2(128)

Table name

SUPPORT_MODE

VARCHAR2(6)

Capture process support level for the table:

  • FULL – A capture process can capture changes made to all of the columns in the table.

  • ID KEY – A capture process can capture changes made to the key columns and any other columns in the table that are supported by the capture process, except for LOB, LONG, LONG RAW, and XMLType columns.

  • NONE – A capture process cannot capture changes made to any columns in the table.

EXPLANATIONFoot 1

VARCHAR2(4000)

Reason the table does not have FULL capture process support

This column is populated only when both of the following conditions are met:

  • The value of the COMPATIBLE initialization parameter is 20.0 or higher
  • The value of the SUPPORT_MODE column is ID KEY or NONE

Footnote 1 This column is available starting with Oracle Database 21c.

See Also:

“DBA_XSTREAM_OUT_SUPPORT_MODE”


数据运维技术 » Oracle 视图 ALL_XSTREAM_OUT_SUPPORT_MODE 官方解释，作用，如何使用详细说明
分享到：

相关推荐