The parent table is in replication and the child table is not in replication. However, when the child table is dropped on source, the parent table gets dropped from replication and is also dropped on target.
For example:
1. Source table tab1 in config.
2. On source: create a table tab2 with a foreign key reference to tab1.
3. drop table tab2
4. This ends up dropping tab1 from replication and issues the command to drop tab1 on the target
Issuing a DDL on a non-replicated child table in the parent-child relationship causes capture to replicate the DDL on the replicated parent table. This happens if there is any IOT table in replication even if the parent/child table is not IOT table.
WORKAROUND:
None
STATUS:
Issue fixed in version 7.6.3.26 . The latest version of SharePlex for Oracle can be downloaded at:
https://support.quest.com/es-es/shareplex/download-new-releases
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy