Logical DG won't work with ROWIDs period, right?
From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Mon, 10 Mar 2014 08:25:52 -0500 (CDT)
Message-ID: <6b210c3b813a06d4406e4c4a3a6c6cbb.squirrel_at_society.servebeer.com>
Hey all,
Date: Mon, 10 Mar 2014 08:25:52 -0500 (CDT)
Message-ID: <6b210c3b813a06d4406e4c4a3a6c6cbb.squirrel_at_society.servebeer.com>
Hey all,
Just looking for some outside confirmation: I've read in the docs that "ROWID datatypes" are not supported for a logical data guard setup in 11.2. I assume that to mean that queries and DML with ROWID in the WHERE clause will fail to copy?
I understand that logical DG is a SQL apply and that ROWIDs do not have to match, but that seems different from saying the datatype isn't supported. I take that to mean a column in a table rather than a SQL statement.
I'm thinking we're going to need Active Data Guard then, in order to get our reporting DB... [sigh]
Thanks!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 10 2014 - 14:25:52 CET