Database Error Messages

ORA-40853

Multi-Value Index (MVI) must be created with ERROR ON ERROR, NULL ON EMPTY and NULL ON MISMATCH.

Cause

An attempt was made to create a multi-value index without using ERROR ON ERROR, NULL ON EMPTY, and NULL ON MISMATCH.


Action

Add ERROR ON ERROR, NULL ON EMPTY, and NULL ON MISMATCH when creating a multi-value index.