DDL goes between two and only two databases. Is there more than one spoke involved?
Active-active (bi-directional) replication of Oracle DDL is supported between two (and only two) databases that contain identical metadata.
Thanks for your response.
We are replicating between one Hub and spoke environment only. Our requirement is the tables/packages will be created in Hub environment at run time and it need to be replicated at spoke. Whether DDL replication allows such replications?
Kindly provide some detail information which will really help us .
Thanks in Advance.
You can use DDL replication between the hub and *one and only one* of the outlying spoke databases.
It means the replication doesn't support Hub with Multiple Spokes right?
DDL - no. Hub to one and only one spoke. DML - absolutely. Hub to many spokes.
Could you please provide more detail on why DDL replication doesn't support multiple spokes? Any Link/docs for reference will be helpful.
Umm, that's just how GoldenGate was architected? DDL is much more complex than just replicating data via DML. DDL has implicit commits (before and after), so managing checkpoints and the complexity of synching that with CSNs related to DML operations would be my guess as to why there is a DDL limitation.