In contrast to the IBM DB2 Universal Database, Oracle logs all LOB data (except for BFILE datatypes) in the Oracle redo log. This allows the Replication Agent to apply each individual LOB change. However, for BFILE data, the same technique is used as for Replication Agent for UDB, and the same limitation exists—BFILE data is not logged but read from the database at the time the rest of the transaction is processed. If two consecutive transactions modify the same bfile, the same inconsistency described previously can occur.
