RE: Logical DG won't work with ROWIDs period, right?
Date: Mon, 10 Mar 2014 10:13:02 -0500 (CDT)
Message-ID: <3dce4c6af18d4df9514d809d8ccd4413.squirrel_at_society.servebeer.com>
Mark (mwf) replies:
> Are you talking about supporting update queries of the form update
> <some_table> set {some column assignments} where rowid in (<some list of
> rowids on the source>)?
> That will not work.
And that's exactly what I figured. However, the documentation makes this slightly confusing as it specifically says that the ROWID "datatype" isn't supported.
> Next question: Do you need Active Dataguard? That depends on how quickly you
> want to be able to query changes on the target. If something like "as of
> last night at midnight" is good enough and IF you have space and appropriate
For the sake of argument, I'll say that the business demands are within an hour. I know, I know...
> Did I mention this is not the appropriate solution for everyone? Check. We
> probably do not need a laundry list of the cases where it is less good than
> active DG, since I hope most of them are obvious.
Painfully obvious. I just wanted confirmation that my interpretation of the docs was reality.
Thanks Mark!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 10 2014 - 16:13:02 CET