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 |
|---|---|---|---|
|
|
| Name of the outbound server |
|
| Name of the user who can connect to the outbound server and process the outbound LCRs | |
|
| Name of the Replication capture process | |
|
| Database where the transaction originated | |
|
| Current user who is enqueuing captured messages | |
|
|
| Owner of the queue associated with the outbound server |
|
|
| Name of the queue associated with the outbound server |
|
| User comment | |
|
| Date when the outbound server was created | |
|
| Status of the outbound server:
| |
|
|
| |
|
| The SCN from which the outbound server’s capture process started capturing changes when it was last started | |
|
| The time from which the outbound server’s capture process started capturing changes when it was last started | |
|
| The global name of the source root database | |
|
| LCR ID format currently being used |
See Also:
“DBA_XSTREAM_OUTBOUND”
编辑:一起学习网
标签:服务器,前缀,视图,注释,信息