JSON column OCI Error ORA-02290: Check Constraint Violated (status = 2290)
(Doc ID 2282399.1)
Last updated on JULY 06, 2017
Applies to:Oracle GoldenGate - Version 22.214.171.124.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 "MSP"."J_ORDERS"
( "ID" VARCHAR2(250 CHAR) NOT NULL ENABLE,
"ACCOUNTID" VARCHAR2(250 CHAR),
"COMCASTACCOUNTGUID" 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