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,

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]


Received on Mon Mar 10 2014 - 14:25:52 CET

Original text of this message