TimesTen Error Messages

TT-02419

All columns in a primary key constraint must be in the initial partition; column column_name was added by ALTER TABLE


Cause

When you use the ALTER TABLE statement to add a column, the newly added column is located in a secondary partition. You cannot use the ALTER TABLE statement to add a primary key constraint on a column that is in the secondary partition.


Action

Use ttMigrate -r -relaxedUpgrade to condense the secondary partition into a single partition. Once you condense the partitions, you can then ALTER the table and add a primary key constraint on the column. For more information on partitions and using ALTER TABLE, see ALTER TABLE in Oracle TimesTen In-Memory Database SQL Reference.


Additional Information

TimesTen did not create a primary key on the specified column because it is in a secondary partition.