Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  Oracle Tips by Burleson

Oracle Streams
Chapter 2 - Streams Components and Processes

Row LCRs

  • object_owner - This is the schema name that contains the table with the changed row.
     

  • object_name - This is the name of the table that contains the changed row.
     

  • tag - This is a raw tag that can be used to track the LCR.
     

  • transaction_id - This is the identifier of the transaction in which the DML statement was run.
     

  • scn - This is the system change number (SCN) at the time when the change record was written to the redo log.
     

  • old_values - These are the old column values related to the change. These are the column values for the row before the DML change. If the type of the DML statement is UPDATE or DELETE, these old values include some or all of the columns in the changed row before the DML statement. If the type of the DML statement is INSERT, there are no old values.
     

  • new_values - These are the new column values related to the change. These are the column values for the row after the DML change. If the type of the DML statement is UPDATE or INSERT, these new values include some or all of the columns in the changed row after the DML statement. If the type of the DML statement is DELETE, there are no new values.

DDL LCRs

DDL LCRs contains the DDL changes. A DDL statement changes the structure of the database. For example, a DDL statement may create, alter, or drop a database object.

Each DDL LCR contains the following information:

  • source_database_name - This is the name of the source database where the DDL change occurred.
     

  • command_type - This is the type of DDL statement that produced the change, for example ALTER TABLE or CREATE INDEX.
     

  • object_owner - This is the schema name of the user who owns the database object  in which the DDL statement was run.


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

 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.