Database Administration (MOSC)

MOSC Banner

ORA-02290: Check constraint (sys.ensure_json) violated

We are migrating database charaterset to uta8 using DMU, but came across this error.

The DMU process was trying to update the table with: update sys.modelalg$ set MDATA= SYS_OP_CSCONV(MDATA.'AL16UTF16'

Looking into the constraint, it's

ALTER TABLE SYS.MODELALG$ ADD (
CONSTRAINT ENSURE_JSON
CHECK (mdata IS JSON)
ENABLE VALIDATE);

strangely, not all databases have this table sys.modelalg$, and there is little info out there for this table either.

Please share your idea on this.

Database version: 19.25

server: rhel 7

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center