[Home] [Help] [Dependency Information]
Object Name: | CDB_STREAMS_SCHEMA_RULES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Schema rules created by streams administrative APIs in all containers
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 | (30) | Yes | Name of the rule to be applied |
RULE_OWNER | VARCHAR2 | (30) | Yes | Owner of the rule |
RULE_CONDITION | VARCHAR2 | (4000) | Generated rule condition evaluated by the rules engine | |
CON_ID | NUMBER | container id |
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
, CON_ID
FROM SYS.CDB_STREAMS_SCHEMA_RULES;
SYS.CDB_STREAMS_SCHEMA_RULES does not reference any database object
SYS.CDB_STREAMS_SCHEMA_RULES is referenced by following:
|
|
|