Oracle GoldenGate Error Messages

OGG-02717

DDL is too large or partial. DDL is ignored. Details: {0} DDL statement with marker sequence [{1}], ddl sequence [{2}], redo sequence [{3}], rba [{4}], thread id [{5}], start SCN [{6}], commit SCN [{7}] length [{8}] for {9}.{10}/{11} will be ignored. Either the length of DDL exceeded the supported maximum size or a partial DDL is received due to insufficient BUFSIZE. Increase the BUFSIZE if a partial DDL is received and the actual DDL size is less than the supported maximum size.


Cause

A DDL statement that exceeds the size supported by Oracle GoldenGate will be ignored. Partial DDLs will also be ignored.


Action

If using the pre 19.1 trail file format, use the 19.1 trail file format. If running Oracle Extract, specify large enough buffer size to hold entire DDL text by TRANLOGOPTIONS BUFSIZE option. A future DML may cause an error if discarding the DDL causes metadata inconsistencies. In any case, you can apply the DDL on the target manually. You might need to restart processes if the condition caused an error.