-
Title
Can a source table replicate to two different target tables on the same target database? -
Description
Can a source table replicate to two different target tables on the same target database?
-
Cause
General information. -
Resolution
A. It works fine for normal replication, meaning that a source table can replicate to two different target tables in the same target database.
B. However, it does not work if one table is replicating in normal and the other one is replicating in partitioned manner (vertical or horizontal). The following errors are seen:
Info 2016-01-18 12:42:30.504212 7554 1 Activation of "config2a", actid 22, for sid o.syam complete
Info 2016-01-18 12:42:30.497610 7554 1 Deactivation of "config2", actid 21, for sid o.syam started
Info 2016-01-18 12:42:30.495555 7554 1 Compile of "config2a" for sid o.syam: Not all tables activated successfully
Warning 2016-01-18 12:42:25.622709 7554 1 Activation: Skipping duplicate entry for "SHA86"."TABLE3" in line 4 - Source is defined in line 5 with vertical partitioning and a vertically partitioned table may be defined only once. (activating sid syam) [module ocf]
Notice 2016-01-18 12:42:24.877892 7554 1 Activation: Oracle compatible parameter='11.1.0.0.0'. (activating sid syam) [module ocf]
Notice 2016-01-18 12:42:20.736114 7554 1 Activation: Replicating according to target compatibility of "8.6.2.0" (activating sid syam) [module utl]
Notice 2016-01-18 12:42:20.731556 7554 1 Activation: Replicating according to target compatibility of "8.6.2.0" (activating sid syam) [module utl]
Info 2016-01-18 12:42:19.097418 7554 1 Activation launched, pid = 7554 (activating sid syam)
To resolve the problem in para B, the table will have to replicate in either normal replication or in partitioned replication but not both.