TimesTen Error Messages

TT-02241

Primary or Unique key cannot be created, constraint already exists for table table_name on column column_name


Cause

You attempted to specify a unique or primary key on a table that already has the other such key on that column.


Action

Check the constraints defined on the columns of the table, ensuring that the column you want to add a unique constraint to does not have one already defined. Run the ttIsql command, indexes, to view the constraints on the table. 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 perform the operation.