Add a Time-Based Aging Policy to a Table

To add an aging policy to a regular table or a cache table, under the Tables node, right-click the name of the table that you want to add an aging policy to. An aging policy can be added to a cache table only if it is the root table of a cache group.

After you right-click the name of the table that you want to add an aging policy to, select Aging, then Add Time-based to add a time-based aging policy.

To add a time-based aging policy to the table, in the Prompts tab of the Add time-based dialog box, select the column from the Column pull-down menu that you want to store the timestamp value indicating when each row was added or most recently updated.

Indicate the length of time in which data that has not been updated is to be kept in the table by specifying, in the Life-time field, a numeric value followed by a unit of minutes, hours or days in the pull-down menu.

Indicate the frequency at which data is to be aged out of the table by specifying, in the Cycle field, a numeric value followed by a unit of minutes, hours or days in the pull-down menu. The default time-based aging cycle is 5 minutes.

Specify an aging state by selecting either the on or off button in the Time-based aging field. The default aging state is on. Then click the Apply button to add the time-based aging policy to the table.

A time-based aging policy can only be added to a table that contains a non-nullable DATE or TIMESTAMP column.

Related Topics

TimesTen Tasks

SQL Developer Concepts and Usage