ORA-26840: Optimized capture and apply is disabled because an Apply operation for the source database can not be identified. (Doc ID 2268632.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

 In CDC  “Asynchronous Distributed Hotlog” with upstream capture you see following error in alert log file from source database:

ORA-26840: Optimized capture and apply is disabled because an Apply operation for the source database can not be identified.
ORA-26840: Optimized combined capture and apply is disabled because streams can not identify an Apply operation for the source database "ORCL"
ORA-02063: previous line of DBLINK_NAME

Although capture starts just fine, no changes are propagated to destination.

Changes

 After setting up second change set for CDC

Cause

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