I am trying to setup streams in 10g.
Oracle support all types CLOB/BLOBs in 10g unlike 9i.
But when I tried to setup conflict resolution and supplimental logging I got
"invalid datatype" error. I am using pre-build conflict resolution methods.
I think using a LOB in conflict resolution requires you to skip Oracle's pre-built handlers and write your own. From the Streams admin guide, "Prebuilt update conflict handlers do not support LOB, LONG, LONG RAW, and user-defined type columns."