TimesTen Error Messages

TT-02786

Column column_name already has unique constraint


Cause

You attempted to issue an ALTER TABLE statement to add a UNIQUE constraint, but there was a UNIQUE constraint previously defined for the column.


Action

Check the constraints defined on the columns of the table, making sure the column you want to add a constraint to does not have a unique constraint defined on it. Run the ttIsql indexes command on the table to display the constraint information. For more information, see ALTER TABLE in Oracle TimesTen In-Memory Database SQL Reference or ttIsql in the Oracle TimesTen In-Memory Database Reference.


Additional Information

TimesTen did not alter the table to add the constraint.