[Home] [Help] [Dependency Information]
Object Name: | ALL_STREAMS_TABLE_RULES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Rules created by streams administrative APIs on tables visible to the current user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STREAMS_NAME | VARCHAR2 | (128) | Name of the streams process: capture/propagation/apply process | |
STREAMS_TYPE | VARCHAR2 | (12) | Type of the streams process: CAPTURE, PROPAGATION or APPLY | |
TABLE_OWNER | VARCHAR2 | (128) | Owner of the table selected by this rule | |
TABLE_NAME | VARCHAR2 | (128) | Name of the table selected by this rule | |
RULE_TYPE | VARCHAR2 | (7) | Type of rule: DML or DDL | |
DML_CONDITION | VARCHAR2 | (4000) | Row subsetting condition | |
SUBSETTING_OPERATION | VARCHAR2 | (6) | DML operation for row subsetting | |
INCLUDE_TAGGED_LCR | VARCHAR2 | (3) | Whether or not to include tagged LCR | |
SOURCE_DATABASE | VARCHAR2 | (128) | Name of the database where the LCRs originated | |
RULE_NAME | VARCHAR2 | (128) | Yes | Name of the rule to be applied |
RULE_OWNER | VARCHAR2 | (128) | Yes | Owner of the rule |
RULE_CONDITION | VARCHAR2 | (4000) | Generated rule condition evaluated by the rules engine |
Cut, paste (and edit) the following text to query this object:
SELECT STREAMS_NAME
, STREAMS_TYPE
, TABLE_OWNER
, TABLE_NAME
, RULE_TYPE
, DML_CONDITION
, SUBSETTING_OPERATION
, INCLUDE_TAGGED_LCR
, SOURCE_DATABASE
, RULE_NAME
, RULE_OWNER
, RULE_CONDITION
FROM SYS.ALL_STREAMS_TABLE_RULES;
|
|
|