Change the Lifetime and Cycle for a Table's Time-Based Aging Policy

To change the lifetime and cycle for a regular table's or cache table's existing time-based aging policy, under the Tables node, right-click the name of the table that you want to change the lifetime and cycle for.

After you right-click the name of the table that you want to change the lifetime and cycle for, select Aging, then Change Lifetime and Cycle.

In the Prompts tab of the Change Lifetime and Cycle dialog box, change 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.

Change 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.

Click the Apply button to change the lifetime and cycle for the table.

Related Topics

TimesTen Tasks

SQL Developer Concepts and Usage