[Home] [Help] [Dependency Information]
Object Name: | ALL_STREAMS_SCHEMA_RULES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Rules created by streams administrative APIs on all user schemas
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 | |
SCHEMA_NAME | VARCHAR2 | (128) | Name of the schema selected by this rule | |
RULE_TYPE | VARCHAR2 | (7) | Type of rule: DML or DDL | |
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
, SCHEMA_NAME
, RULE_TYPE
, INCLUDE_TAGGED_LCR
, SOURCE_DATABASE
, RULE_NAME
, RULE_OWNER
, RULE_CONDITION
FROM SYS.ALL_STREAMS_SCHEMA_RULES;
|
|
|