Oracle DBA, How To, Error, Cause and Action

ORA-02331: cannot create constraint on column of datatype string

ORA-02331: cannot create constraint on column of datatype string




Cause: An attempt was made to create a constraint on a column posessing a non-constrainable datatype -- VARRAY, nested table, object, LOB, FILE, or REF.




Action: Change the column datatype, or remove the constraint.