My Oracle Support Banner

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

Last updated on JULY 21, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 18.0.0.0 and later
Information in this document applies to any platform.

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

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.