Task 4: Create the Static AWT Cache Group on the TimesTen Database

Create a static AWT cache group.

As the TimesTen cache administration user, create a static AWT cache group with the CREATE ASYNCHRONOUS WRITETHROUGH CACHE GROUP SQL statement. Use the unique index columns as the primary key definition.

The following statement creates an AWT cache group awt_customers that caches the sales.customers table:

CREATE ASYNCHRONOUS WRITETHROUGH CACHE GROUP awt_customers
FROM sales.customers
 (cust_num NUMBER(6) NOT NULL,
  region   VARCHAR2(10),
  name     VARCHAR2(50),
  PRIMARY KEY(cust_num));

Note:

This SQL statement creates the cache group and the cache tables on the TimesTen database.

When you choose data types for columns in the TimesTen cache tables, consider the data types of the columns in the Oracle Database tables and choose an equivalent or compatible data type for the columns in the cache tables. See Mappings Between Oracle Database and TimesTen Data Types