O'Reilly logo

Oracle Streams 11g Data Replication by Kirtikumar Deshpande

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 9Data Transformations

One of the strongest features of Oracle Streams replication is data transformation. The contents in the Logical Change Record (LCR) can be modified as it flows through the replication process. The transformation of the data is done in the LCRs. Oracle calls such modifications rule-based transformations because they are performed after the rule evaluates to TRUE.

Such transformations are required when the source and destination objects are not identical but data must be replicated. For example, the destination table name may not be the same, the schema name may not be the same, some of the columns in source tables may not exist or may not have the same data type at the destination, and so forth. In such cases, the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required