My Oracle Support Banner

Replicat Abends With ORA-12081: update operation not allowed on table (Doc ID 2712035.1)

Last updated on JULY 18, 2023

Applies to:

Oracle GoldenGate - Version 12.3.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate 12.3 replicat abends with:

WARNING OGG-01154  SQL error 12081 mapping <OWNER>.<TABLE> to <OWNER>.<TABLE>
OCI Error ORA-12081: update operation not allowed on table "<OWNER>"."<TABLE>" (status = 12081),
SQL <UPDATE "<OWNER>"."<TABLE>" x SET x."<COL2>" = :a1,x."<COL3>" = :a2 WHERE x."<COL1>" = :b0>.
OGG-01296 Error mapping from <OWNER>.<TABLE> to <OWNER>.<TABLE>.

Cause

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
Symptoms
Cause
Solution


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