Oracle 5.0, Reference Manual

Page: 1505 / 3232

How Servers Evaluate Replication Filtering Rules
1485
• Yes. Continue to step 2.
• No. Execute the statement and exit.
2. Are there any
--replicate-do-table
[1458] options?
• Yes. Does the table match any of them?
• Yes. Execute the statement and exit.
• No. Continue to step 3.
• No. Continue to step 3.
3. Are there any
--replicate-ignore-table
[1458] options?
• Yes. Does the table match any of them?
• Yes. Ignore the statement and exit.
• No. Continue to step 4.
• No. Continue to step 4.
4. Are there any
--replicate-wild-do-table
[1459] options?
• Yes. Does the table match any of them?
• Yes. Execute the statement and exit.
• No. Continue to step 5.
• No. Continue to step 5.
5. Are there any
--replicate-wild-ignore-table
[1460] options?
• Yes. Does the table match any of them?
• Yes. Ignore the statement and exit.
• No. Continue to step 6.
• No. Continue to step 6.
6. Are there any
--replicate-do-table
[1458] or
--replicate-wild-do-table
[1459]
options?
• Yes. Ignore the statement and exit.
• No. Execute the statement and exit.
16.2.3.3. Replication Rule Application
This section provides additional explanation and examples of usage for different combinations of
replication filtering options.
Some typical combinations of replication filter rule types are given in the following table:
Condition (Types of Options) Outcome
No
--replicate-*
options at all: The slave executes all events that it receives from the
master.