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

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

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:

www.oracle-script.com

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