Auto-Add behavior with <strong>create/drop table and create/drop index DDLs</strong> (4264294)

Auto-Add behavior with create/drop table and create/drop index DDLs

When SP_OCT_REPLICATE_ALL_DDL is set to 0 and SP_OCT_REPLICATE_DD is set to 3, will create/drop table, create/drop index DDLs be replicated ?

Question

In Sharepelx version 7.5 and above using Oracle wildcards in the configuration file with expand keyword and SP_OCT_REPLICATE_ALL_DDL set to 0 and SP_OCT_REPLICATE_DDL set to 3 the  Create/Drop Table and Create/Drop Index DDLs will be replicated.

Example of Oracle wildcard setting in config file :

 expand schema.% schema.%      target_host@o.target_SID

 Above example will replicate all mentioned DDLs for any table within that schema

Shareplex Version 7.5 Admin Guide has more details on how to configure Oracle Wildcards.