ORA-1403 ORA-942 ON DEFERROR WHEN REPLICATING LOBS (Doc ID 1057036.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.5.0 [Release 9.2 to 10.2]
Information in this document applies to any platform.
Advanced Replication Environment with Master Sites below 11.1.


Symptoms

In an advanced replication environment you find on deferror view transactions that have failed with error ORA-942 followed by ORA-1403 error.

The error is caused due to a call that is an UPDATE or an INSERT on a table with LOB.
See Doc ID 2065172.102 to see the contents of failing call.

Notes on Doc ID 1010810.102 have been visited and do not find the cause of the error.

Changes

A new set up of advance replication environment has been created or it has been modified to include replication of tables with LOB contents.

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