The following type of messages are observed in the event_log:
Capture: Table OWNER.TABLENAME is dropped from replication. (capturing from <NAME>) [module oct]
This solution delves on the implications of such messages.
General information.
With the advent of auto add feature in Shareplex whereby a table is brought into replication automatically when it is instantiated, there are some additional behaviors:
When a regular table is created under the schema specified under the auto add feature, the table is automatically brought into replication. However, when the table is dropped on source database, the Shareplex also removes it from replication. The messages “Capture: Table OWNER.TABLENAME is dropped from replication” are meant to notify the users that the said table which was earlier replicating is now dropped from replication.
However, in the context of temporary tables, these messages are of no significance. If a temporary table is dropped from replication, it does not mean much since its content is not of use as far as the target is concerned.
