The parameter SP_OCT_REPLICATE_DDL is for replicating supported DDLs on the tables in replication. The parameter SP_OCT_REPLICATE_ALL_DDL is meant for replicating supported DDLs on the non-replicating tables. Such DDLs are termed as 9i DDL or 9i Supported DDL and the DDL are not restricted to Oracle 9i but rather to all Oracle versions from 9i and up, subject to Shareplex version supporting this feature.
General information.
Here are the points to be noted:
A. Non-replicating tables:
The Shareplex Release Notes section " Supported operations and objects for DDL replication” delves on supported DDLs on non-replicating objects which are enabled when the parameter SP_OCT_REPLICATE_ALL_DDL is set to 1.
B. Replicating tables:
For replicating tables, the setting of SP_OCT_REPLICATE_DDL (which can be 0 if no DDL is to be replicated, 1 if supported DDLs other than TRUNCATE are to be replicated, 2 if only TRUNCATE are to be replicated and 3 if all supported DDL are to be replicated) governs the DDL replication.
Please Note: Starting with Shareplex 7.0 and higher, there is a clear demarcation between the functioning of the parameters SP_OCT_REPLICATE_ALL_DDL and SP_OCT_REPLICATE_DDL. So there is no question of which one takes precedence. Earlier there used to be a complex matrix that one needed to refer to if both these parameters were enabled.
The “9i DDL” or “9i Supported DDL” are now termed as “expanded DDL support” to reflect the fact that they were never tied to an Oracle version but rather, SharePlex started supporting such DDL on non-replicating objects starting with SharePlex versions compatible with Oracle 9i and up.
See Solution #s SOL52606 about what can cause SP_OCT_REPLICATE_ALL_DDL to fail to sync the structure on target objects and SOL36703 about what is 9i supported DDL.
