TimesTen Error Messages

TT-03023

Aging column 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 add a time-based aging policy 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 set a time- based aging policy on the column.

For more information on partitions, see ALTER TABLE in Oracle TimesTen In-Memory Database SQL Reference.


Additional Information

TimesTen cannot perform the SQL operation.