Oracle教程 2023-02-23

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

ALL_CAPTURE_EXTRA_ATTRIBUTES视图是捕获网络数据包中附加属性的一个视图，其用于描述单个流量拦截器抓取网络数据包中存储的额外属性或值。

使用ALL_CAPTURE_EXTRA_ATTRIBUTES视图可以获取附加属性信息，以及收集流量拦截器抓取的附加数据。要使用该视图，首先要确定要查询的流量拦截器ID，然后使用以下SQL语句查询：

SELECT * FROM all_capture_extra_attributes WHERE capture_id = ;

ALL_CAPTURE_EXTRA_ATTRIBUTES displays information about the extra attributes for the capture processes accessible to the current user.

Related View

DBA_CAPTURE_EXTRA_ATTRIBUTES displays information about the extra attributes for all capture processes in the database.

Column	Datatype	NULL	Description
`CAPTURE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the capture process
`ATTRIBUTE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the extra attribute
`INCLUDE`	`VARCHAR2(3)`		Indicates whether the extra attribute is included (`YES`) or not (`NO`)
`ROW_ATTRIBUTE`	`VARCHAR2(3)`		Indicates whether the extra attribute is a row LCR attribute (`YES`) or not (`NO`)
`DDL_ATTRIBUTE`	`VARCHAR2(3)`		Indicates whether the extra attribute is a DDL LCR attribute (`YES`) or not (`NO`)