SQL Server OGG-05268 Change Data Capture Failed - SQLCODE 325 - Compatibility Level Of The Current Database

(Doc ID 2411462.1)

Last updated on JUNE 19, 2018

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

Goal

When trying to add trandata for a cdc

2018-05-14 20:23:29  ERROR   OGG-05268  Change data capture failed for the table 'dbo.WIRES' in the database 'fedlink': error: SQLCODE 325. SQL Error [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'MERGE'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms