My Oracle Support Banner

Streams Rules Recommendations (Doc ID 353609.1)

Last updated on NOVEMBER 06, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.1 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

When configuring streams here are the general tips for Using Rules

Scope

A rule is a database object that instructs a client to perform an action
when an event occurs. Each rule is specified as a condition that is similar
to the condition in the WHERE clause of a SQL query. Rules are evaluated by
a rules engine, which is a built in part of Oracle.Hence here we define some
tips for using rules

 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Rules
 Tip #1:  Spelling Counts!
 Tip #2:  Source_database_name = GLOBAL_NAME of source database
 Tip #3: Eliminate duplicate rules
 Tip #4: Avoid including tables with unsupported datatypes
 Tip #5: Avoid complex rules wherever possible
 Tip #6:  Use views to look at ruleset and rules

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.