My Oracle Support Banner

How to exclude operations in a Streams environment (Doc ID 814602.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.



Goal

This note will help us to exclude tables ,schemas and specific class of objects. (like Synonym), commands like 'Truncate Table,'alter table', 'create index' by using negative rules or by altering the rules.

This script is provided for educational purposes only and not supported by OracleSupport Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.

Proofread this script before using it! Due to the differences in the way text editors, e-mail packages and operating systems handle text formatting (spaces, tabs and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected.

Solution

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
Goal
Solution
 Overall Steps
 A. Stop the capture process:
 B. Check the existing capture rules:
 C. Create new negative rules or alter the existing rules
 Example: How to exclude a table from schema level replication by using negative rule condition
 Example: How to exclude a table from the schema level replication by altering the rules
 
Example: How to exclude schema from global level Streams replication
 Example: How to exclude the required commands like 'Alter Table'
 Example: How to exclude TRUNCATE TABLE command at table level
 Example: How to avoid capture of DDL to an entire class of objects at the schema or global level
 D. Check for any errors
 E. Start the capture process
 F. Data Dictionary views
References

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