Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Unanswered: streams LOB support issue in 10g

    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.

    Is there any work around that you may be knowing?


  2. #2
    Join Date
    Sep 2003
    Virginia, USA
    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."
    Author, Oracle Database 10g: From Nuts to Soup

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts