I've moved...

This blog now has a new home - please update your shortcuts and readers to: www.jeffkemponoracle.com. Sorry for any inconvenience!

Monday, October 24, 2005

Avoiding Lost Updates #3: The Solution

Background: see my earlier posts Avoiding Lost Updates
and Avoiding Lost Updates #2: Updateable Views

I've discussed this problem with my colleagues and have come up with a number of potential solutions, one of which we believe is bulletproof.

[Full Article]

3 comments:

  1. How about max(ora_rowscn) instead of sum(ora_rowscn) ?

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. Hi Darren,

    Yes, I believe SUM(ora_rowscn) is the way you would do it, if you chose to use ora_rowscn - assuming ORA_ROWSCN is always greater for later transactions?

    In fact, I had thought of this previously, but then promptly forgot it while writing this post.

    Thanks!

    Jeff

    ReplyDelete

Note: only a member of this blog may post a comment.