Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Logical Change Records > Modifying LCR Contents

Modifying LCR Contents

When replicating data, sometimes there is a business requirement that sensitive data be masked or changed. Sometimes businesses simply want to update a delete flag in the replicated data rather than physically delete it, so the LCR for the DELETE operation is changed to an UPDATE operation to achieve this. Such modifications are done mainly to the row LCR contents. Modifications to the DDL LCR contents typically are very limited. If you replicated DDL changes and the tables are in a different schema at the destination, you will need to modify the schema name in the LCR as well as the DDL text if the schema name is used to qualify the table name in the DDL command at the source database.

Modifying Row LCR Contents

The DML handler example in Chapter 6 showed how to change the value for the SSNO column of the SCOTT.EMP table. Refer to that example to see how the data was modified in the LCR.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint