Task 1: Identify the Schema on the Oracle Database

On the Oracle database, use SQL*Plus to:

1. Identify Oracle Database tables to cache.

   Since the cache tables are based on the tables you want to cache in the Oracle Database, identify the Oracle Database tables that are to be cached.

   Each table should be either:

   • An Oracle Database table with a primary key on non-nullable columns. The TimesTen cache table primary key must be defined on the full Oracle Database table primary key.

   • An Oracle Database table with non-nullable columns upon which a unique index is defined on one or more of the non-nullable columns in the table. The TimesTen cache table primary key must be defined on all of the columns in the unique index.

   For example, you decide to cache the sales.customers table on the Oracle database. Then, note that the definition of the customers tables is:

   CREATE TABLE sales.customers
   (cust_num NUMBER(6) NOT NULL PRIMARY KEY,
    region   VARCHAR2(10),
    name     VARCHAR2(50),
    address  VARCHAR2(100));
   Table created.

2. Since these tables are going to be cached in a read-write cache group, grant the SELECT, INSERT, UPDATE and DELETE privileges on the customer table to the Oracle cache administration user:

   SQL> GRANT SELECT, INSERT, UPDATE, DELETE ON sales.customers TO cacheadmin;