4 Replies Latest reply: Mar 27, 2013 12:25 PM by johnnied RSS

    streams error : update options

    johnnied
      is there an option for an apply process to ignore column differences on non-primary keys for UPDATE LCRs , and simply update the differing columns as necessary ?

      I don't fancy the idea of writing error handlers for each table.

      johnnie

      sorry - -- 11.2.0.3

      I was thinking of more than just setting "compare_key_only" as an apply process parameter, i am looking for something that might automatically update unexpected non-primary key column differences.

      Edited by: johnnie d on 27-Mar-2013 16:43

      Edited by: johnnie d on 27-Mar-2013 16:45