Oracle 视图 DBA_STREAMS_KEEP_COLUMNS 官方解释,作用,如何使用详细说明
本站中文解释
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 |