Description of the illustration roquicks7.eps

The image shows the following SQL statements:

INSERT INTO readtab VALUES (3,'Welcome');
DELETE FROM readtab WHERE keyval=2;
UPDATE readtab SET str='Hi' WHERE keyval=1;

The following row is inserted into the oratt.readtab cached Oracle table:

keyval str
     3 Welcome

The row where keyval=2 is deleted from the oratt.readtab cached Oracle table. The row where keyval=1 in the oratt.readtab cached Oracle table is updated such that the value in the str column is changed to Hi.

After the INSERT, DELETE and UPDATE statements have been committed on the cached Oracle table, they are automatically refreshed into the oratt.readtab cache table in the readcache read-only cache group within the TimesTen database. As a result, the TimesTen cache table and the cached Oracle table contain the following rows:

keyval str
     1 Hi
     3 Welcome

End of description.