ORA-1403 ORA-942 ON DEFERROR WHEN REPLICATING LOBS
Last updated on MAY 05, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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.
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.
A new set up of advance replication environment has been created or it has been modified to include replication of tables with LOB contents.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms