When tables are created or dropped in the source database where the active config file is using wildcard, the following messages appear in the event log (shown here for both scenarios):
When table is dropped:
Notice 2016-09-27 16:26:30.859912 13424 1 Capture: Table OWNER.TABLE1 is dropped from replication. (capturing from source_SID) [module oct]
When table is created:
Info 2016-09-27 16:26:57.370809 13424 1 Table OWNER.TABLE2 (object id 204368) has been added to replication (capturing from source_SID)
This article explains how SharePlex deals with CREATE/DROP of tables that conform to the wildcard specification in an active config file.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center