My Oracle Support Banner

Primary Note for Troubleshooting Streams Apply Errors ORA-1403, ORA-26787 or ORA-26786,Conflict Resolution (Doc ID 265201.1)

Last updated on NOVEMBER 10, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This article covers how to diagnose Apply Streams errors when the Apply process gets a data error when applying a transaction, like errors ORA-1403, ORA-26787 or ORA-26786

This does not cover critical errors suffered by the apply process that are not related to data errors.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 Retrieve information about the error
 View failed LCR
 Check data on the target side
 Enable Tracing
 Identify root cause
 Supplemental Logging
 Key columns identification
 Triggers and Constraints
 Transformations and Handlers
 DDL operations
 Unrecoverable operations
 Other possible causes
 Data modification on target site
 Fixing the error
 Data Correction
 Reexecuting the error
 Deleting error from error queue
 Avoid new errors
References

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