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

Get Oracle Streams 11g Data Replication now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.