Return
-
Title
How does Shareplex handle DDL replication when it is turned off but wildcards are used with SP_OCT_AUTOADD_ENABLE turned on? -
Description
How does Shareplex handle DDL replication when it is turned off but wildcards are used with SP_OCT_AUTOADD_ENABLE turned on?
-
Cause
General information -
Resolution
The DDL to create target table will still occur if a table is created on source and qualifies under wildcard specification, regardless of DDL replication turned off. However, it is only the CREATE TABLE DDL that is replicated. The other DDLs will depend on the settings of the parameters SP_OCT_REPLICATE_DDL which governs whether a DDL on the tables in replication is replicated across to the target.