[Home] [Help] [Dependency Information]
Object Name: | ALL_STREAMS_GLOBAL_RULES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Global rules created on the streams capture/apply/propagation process that interact with the queue 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 | (11) | Type of the streams process: CAPTURE, PROPAGATION or APPLY | |
RULE_TYPE | VARCHAR2 | (9) | Type of rule: DML, DDL or PROCEDURE | |
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
, RULE_TYPE
, INCLUDE_TAGGED_LCR
, SOURCE_DATABASE
, RULE_NAME
, RULE_OWNER
, RULE_CONDITION
FROM SYS.ALL_STREAMS_GLOBAL_RULES;
|
|
|