There is a way to have Shareplex replicate creation of certain objects. This is done by way of enabling the replication of 9i DDL or 9i Supported DDL by setting the parameter SP_OCT_REPLICATE_ALL_DDL to 1. The question arises as to whether Shareplex will start replicating any table the moment it was created, since it did replicate the CREATE TABLE command and created the identical table on target.
General information.
It is not possible for Shareplex to be able to automatically replicate a newly created table even though it replicated the CREATE TABLE command for this table and was able to create the table on target. The only way to bring this newly created table into replication is to make a copy of the currently active config file, add this table to the copy and activate the copy. It is possible to instantiate a replicating or non-replicating table by the use of "copy" command of Shareplex but subsequent changes to the table will only be replicated depending on whether the table is already in replication or is brought into replication thereafter.
See Shareplex Reference Guide for details on "activate config", "copy" and SP_OCT_REPLICATE_ALL_DDL.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center