Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy



streams Capture Process Rule Evaluation

Oracle Tips by Burleson 

Oracle Streams
Capture and Propagate Configuration

Capture Architecture

Capture Process Rule Evaluation

The Capture process either captures or discards the changes based on the rules that the DBA defines. The rules of extraction are defined in either a negative or positive rule set. There are basically three levels at which rules and rules sets are defined:

  • A Table rule captures or discards either row changes resulting from DML changes or DDL changes to a specified table. As a part of the table, sub set rules act on a specific set of rows within a table.

  • A Schema rule captures or discards either row changes resulting from DML or DDL changes to the objects in a particular schema.

  • Global rule captures or discards either all row changes from DML changes or all DDL changes in the database.

The Capture Process never captures changes in SYS, SYSTEM or CTXSYS schemas. Since the SYS and SYSTEM maintain the data dictionary for the whole instance and they are also specific to that instance, the tables are never part of the Capture process.

When nologging or unrecoverable SQL operations are used, the resulting changes are never captured by the Capture process. This is because the nologging operations do not create the redo entries.

The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks