5 Methods for Transmitting Changes Between TimesTen and Oracle Databases

You can transmit changes between TimesTen and Oracle databases manually or automatically.

• Manually load cache groups: You can manually load or refresh cache instances into the TimesTen cache tables from the Oracle database tables using LOAD CACHE GROUP or REFRESH CACHE GROUP statements.

• Manually propagate committed changes: Use a FLUSH CACHE GROUP statement to propagate committed changes on the TimesTen cache tables to the cached Oracle Database tables.

• Automatically refresh cache groups: You can cause the cache instances to be automatically refreshed with the AUTOREFRESH cache table attribute. Automatic refresh can be defined on cache groups that are either explicitly or dynamically loaded.

• Dynamically load data on demand: When you define a cache group with the DYNAMIC keyword, then the data in a cache group is dynamically loaded on demand.

• Automatic propagation of changes to the Oracle database: When you configure the PROPAGATE cache table attribute on the TimesTen cache tables, then committed changes are automatically propagated to the cached Oracle Database tables.

See Transmitting Changes Between the TimesTen and Oracle Databases for an overview of each of these methods.

Note:

You can use SQL statements or SQL Developer to perform most of the operations in this chapter. For more information about SQL Developer, see Oracle TimesTen In-Memory Database SQL Developer Support User's Guide.

The following sections describe these operations:

• Manually Loading and Refreshing a Cache Group

• Flushing a User Managed Cache Group

• Unloading a Cache Group

• Automatically Refreshing a Cache Group

• Manually or Dynamically Loading Cache Groups

• Dynamic Cache Groups

• Determining the Number of Cache Instances Affected by an Operation

• Setting a Passthrough Level