ALL_STREAMS_GLOBAL_RULES

ALL_STREAMS_GLOBAL_RULES displays information about global rules created for the Streams capture/apply/propagation processes that interact with queues accessible to the current user.

Related View

• DBA_STREAMS_GLOBAL_RULES displays information about all global rules created by Streams capture/apply/propagation processes.

  Column	Datatype	NULL	Description
  STREAMS_NAME	VARCHAR2(30)		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(7)		Type of rule: DML or DDL
  INCLUDE_TAGGED_LCR	VARCHAR2(3)		Indicates whether to include tagged LCR (YES) or not (NO)
  SOURCE_DATABASE	VARCHAR2(128)		Name of the database where the LCRs originated
  RULE_NAME	VARCHAR2(30)		Name of the rule to be applied
  RULE_OWNER	VARCHAR2(30)		Owner of the rule
  RULE_CONDITION	VARCHAR2(4000)		Generated rule condition evaluated by the rules engine

  See Also: "DBA_STREAMS_GLOBAL_RULES"