Is it possible for Shareplex to selectively replicate some DDL and not replicate other DDLs (on some or all tables)?
General information.
It is not possible to configure Shareplex to selectively replicate DDLs. Or put another way, It is not possible to configure Shareplex in a manner that it will only replicate certain types of DDL or certain types of DDL on specific tables. It can either be configured to replicate all DDLs or replicate none of the DDLs. There is no middle way except for one caveat mentioned at the end of this para. This holds true for both DDL replication involving replicating tables as well as for DDL replication involving non-replicating tables (the latter is also termed as 9i supported DDL). The only exception to this rule is that when DDL are enabled to be replicated for replicating tables, it is possible to either replicate TRUNCATE only, or replicate all other DDL except TRUNCATE or replicate both TRUNCATE and other DDL. This is done by configuring the parameter SP_OCT_REPLICATE_DDL to 2, 1 or 3 respectively.
Here is the description of the parameter SP_OCT_REPLICATE_DDL:
SP_OCT_REPLICATE_DDL, enables you to selectively turn replication of DDL and the TRUNCATE command on and off. If you leave the flag set to the default of 3, all DDL that Shareplex currently supports will be replicated, including the TRUNCATE command. The parameter also provides options to replicate only DDL (not TRUNCATE) or only TRUNCATE (not DDL). You can also disable the replication of both. Default: 3 (replicate DDL and TRUNCATE)
Range of valid values:
0 (disable both DDL and TRUNCATE replication)
1 (enable DDL replication only)
2 (enable TRUNCATE replication only)
3 (enable DDL and TRUNCATE replication)
Takes effect: as soon as it is set.
