GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center