本站中文解释
Oracle视图DBA_STREAMS_KEEP_COLUMNS提供了当前数据库上所有Streams保留字段的信息，其中包括每列在应用程序、消息和消息组中的数据和元数据。 通过使用这个视图，DBA可以查询出数据库中当前所有保留字段的详细信息，也可以确认是否存在特定的保留字段以及它的使用情况。
使用方法：
1.查询某个表的Streams保留字段：
SELECT * FROM DBA_STREAMS_KEEP_COLUMNS WHERE OWNER = ‘OWNER_NAME’ AND TABLE_NAME = ‘TABLE_NAME’;
2.查询数据库所有Streams保留字段：
SELECT * FROM DBA_STREAMS_KEEP_COLUMNS;
官方英文解释
DBA_STREAMS_KEEP_COLUMNS displays information about declarative rule-based transformations that keep a list of columns in a row logical change record (LCR).
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the rule which has an associated transformation |
|
|
|
|
Name of the rule which has an associated transformation |
|
|
|
|
Schema of the column to be kept |
|
|
|
|
Table of the column to be kept |
|
|
|
|
Column to keep |
|
|
|
|
Indicates whether to keep the old ( |
|
|
|
|
|
|
|
|
|
Order in which this transformation should be executed |
