Description of the illustration writequicks7.eps

The image shows the following SQL statements:

INSERT INTO oratt.writetab VALUES (102, 'Cache');
DELETE FROM oratt.writetab WHERE pk=101;
UPDATE oratt.writetab SET attr='Oracle' WHERE pk=100;

The following row is inserted into the oratt.writetab TimesTen cache table:

pk  attr
102 Cache

The row where pk=101 is deleted from the oratt.writetab TimesTen cache table. The row where pk=100 in the oratt.writetab TimesTen cache table is updated such that the value in the attr column is changed to Oracle.

After the INSERT, DELETE and UPDATE statements have been committed on the cache table in the writecache AWT cache group within the TimesTen database, they are automatically propagated to the oratt.writetab cached Oracle table. As a result, the TimesTen cache table and the cached Oracle table contain the following rows:

pk  attr
100 Oracle
102 Cache

End of description.