Re: Replication options with ROWID updates

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Tue, 27 Mar 2018 14:44:39 -0500
Message-ID: <0e2957f0a999a0d651aca51affecaccf_at_society.servebeer.com>



On 2018/03/27 11:21, vit.spinka wrote:

> Note that all logical replication products see the data as they are in the redo - they don't see the original SQL. Thus if the table has a primary key, they will use it to apply the changes - and it does not matter at all whether the user sql was using rowid or whatever else.

Right, but a primary key is required in this case, correct? Not sure how else this would be accomplished...

Thanks!
Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 27 2018 - 21:44:39 CEST

Original text of this message