Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
