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.
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.
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 the Oracle TimesTen In-Memory Database SQL Reference.
Additional Information
TimesTen cannot perform the SQL operation.