ORA-1403 ORA-942 ON DEFERROR WHEN REPLICATING LOBS
(Doc ID 1057036.1)
Last updated on AUGUST 27, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 10.2.0.5.0 [Release 9.2 to 10.2]
Oracle Database Cloud Schema 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
Oracle Database Cloud Exadata Service - Version N/A and later
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!