My Oracle Support Banner

SQL Server OGG-05268 Change Data Capture Failed - SQLCODE 325 - Compatibility Level Of The Current Database (Doc ID 2411462.1)

Last updated on OCTOBER 03, 2022

Applies to:

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


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.<TABLE>' in the database '<DATABASE>': 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.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.