Task 3: Identify Schema Users on the Oracle Database

To be able to cache tables from an Oracle database to a TimesTen database, you need to identify (or create) one or more schema users on the Oracle database.

These schema users own tables that will be cached in the TimesTen database.

Note:

The set of examples included in this guide assume that a schema user (with populated tables) named sales already exists in the Oracle database.

Later on, you will create one or more cache table users on the TimesTen database with the same name as the schema users to coordinate the caching of data between the Oracle and TimesTen databases.