Why SP_OCT_AUTOADD_ENABLE is not supported for Open Target?
The Auto-Add feature is not supported for Open Target. The main reason is, not all objects or datatype that get created on source Oracle database are supported in the corresponding Open Target. So a more controlled approach need to be followed when including newly created objects in replication. To bring any new object into ongoing replication in an Open Target environment, the following steps need to be followed:
1. Make a copy of the active config file, edit the copy to include the objects you want to add to replication.
2. Activate the copy.
The parameter SP_OCT_AUTOADD_ENABLE needs to be set to the non-default value of 0 on the Oracle source whenever that source is replicating to an Open Target. If this is a heterogeneous replicating environment where source is replicating to Oracle target and Open Target, then the setting of 0 will need to be set for the parameter as there is no way to have two different values for this Capture parameter.