JSON column OCI Error ORA-02290: Check Constraint Violated (status = 2290)
(Doc ID 2282399.1)
Last updated on MARCH 25, 2019
Applies to:Oracle GoldenGate - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Consider following table that has a JSON column (in an Oracle database):
CREATE TABLE "TEST"."X_ORDERS"
( "ID" VARCHAR2(250 CHAR) NOT NULL ENABLE,
"XXXID" VARCHAR2(250 CHAR),
"XXXGUID" VARCHAR2(250 CHAR),
"ORDER" CLOB, <======= JSON contents stored in this CLOB column
CONSTRAINT "ENSURE_JSON" CHECK ("ORDER" IS JSON) ENABLE, <=== Constraint to check for JSON content
While replicating this table with Oracle GoldenGate, and INSERT operation gets the replicat to abend with below error:
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