Oracle DBA, How To, Error, Cause and Action

ORA-02329: column of datatype string cannot be unique or a primary key

ORA-02329: column of datatype string cannot be unique or a primary key


Cause:


An attempt was made to place a UNIQUE or a PRIMARY KEY constraint on a column of datatype VARRAY, nested table, object, LOB, FILE or REF.



Action:


Change the column datatype or remove the constraint. Then retry the operation.

No comments:

Post a Comment

Thanks for your comment.