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>
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-lReceived on Tue Mar 27 2018 - 21:44:39 CEST