Task 2: Create the Cache Administration User on the Oracle Database

To be able to cache tables from an Oracle database to a TimesTen database, create a cache administration user on the Oracle database on both the Oracle and TimesTen databases.

The cache administration user on the Oracle database creates and maintains Oracle database objects that store the information used to manage the cache environment.

The following example creates the cacheadmin user (with password cacheadmpwd) in the non-autonomous Oracle Database and specifies the default tablespace for cache management objects, cachetblsp:

SQL> CREATE USER cacheadmin IDENTIFIED BY cacheadmpwd
                DEFAULT TABLESPACE cachetblsp QUOTA UNLIMITED ON cachetblsp;
User created.

For the Transaction Processing workload type, the following example creates the cache administration user:

SQL> CREATE USER cacheadmin IDENTIFYED BY cacheadmpwd QUOTA UNLIMITED ON DATA;

Later on, you will create a cache administration user on the TimesTen database with the same name to coordinate the caching of data between the Oracle and TimesTen databases.