Create Oracle Database Objects Used to Manage Data Caching

You request TimesTen to create Oracle database objects owned by the cache administration user, such as cache and replication metadata tables, change log tables, and triggers when particular cache environment and cache group operations are performed.

Some of these objects are used to enforce the predefined behaviors of cache groups with autorefresh and AWT cache groups.

These Oracle database objects are automatically created if the cache administration user has been granted the required privileges with one of the following SQL*Plus scripts:

• The grantCacheAdminPrivileges.sql Script: Run this script to grant all required privileges to the cache administration user that are required to create Oracle database objects used to manage the caching of Oracle database data when particular cache group operations are performed. The cache administration user then automatically creates Oracle database objects used to manage caching Oracle database data in a TimesTen database.

• The initCacheAdminSchema.sql Script: Run this script to grant all required privileges except for the CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, and EXECUTE ON SYS.DBMS_LOB package privileges. For security reasons, you may not want to grant these privileges. The cache administration user then automatically creates all Oracle database objects used to manage caching Oracle database data in a TimesTen database, except for cache groups that use autorefresh.

If you want to check if the Oracle cache administration user has all of the necessary privileges that are required for cache operations, you can run the The checkAdminPrivileges.sql Script.