Difference of DDL and GETTRUNCATES
Hi everyone,
This is a general question on TRUNCATE.
I am aware that capture and replication of TRUNCATE operations are not enabled by default in Golden Gate and needs to set GETTRUNCATES in the parameter file.
Based from documentations, TRUNCATE is considered as DDL operation.
So, I tried to enable DDL replication in our setup and was able to successfully perform DDL capture and replication for CREATE Table, DROP Table, ALTER Table, except for TRUNCATE Table.
Is it because that is how it is in Oracle Golden Gate? Is there an official documentation explaining this.
Also for DDL OPTYPE option, what are the valid input for them? Does it include TRUNCATE?