My Oracle Support Banner

Streams Rules Recommendations (Doc ID 353609.1)

Last updated on AUGUST 18, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.


When configuring streams here are the general tips for Using Rules


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



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
 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.