Some JSON Constraints Fail to Import with ORA-40664: cannot add additional IS JSON check constraint (Doc ID 2884796.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On 18c or above, the following errors are reported when importing some JSON constraints:

ORA-39083: Object type CONSTRAINT:"%"."%" failed to create with error:
ORA-40664: cannot add additional IS JSON check constraint

For example:

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39083: Object type CONSTRAINT:"OWNER"."CONSTRAINT_NAME" failed to create with error:
ORA-40664: cannot add additional IS JSON check constraint

Failing sql is:
ALTER TABLE "OWNER"."TABLE" ADD CONSTRAINT "CONSTRAINT_NAME" CHECK (BODY IS JSON) ENABLE
ORA-39083: Object type CONSTRAINT:"OWNER"."CONSTRAINT_NAME" failed to create with error:
ORA-40664: cannot add additional IS JSON check constraint

On the 12c source database, the JSON tables have two IS JSON check constraints.

Cause

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