Unable to Create a Cache Group

This section describes problems you might encounter when executing the CREATE CACHE GROUP statement.

Possible cause What to do

User does not have the correct Oracle database privileges to create the cache group type.

See Check Oracle Database Privileges.

User has insufficient access to the database.

You must have CACHE_MANAGER privilege to create a cache group.

The internal/external user does not match the Oracle database user.

The TimesTen user name must be the same as the Oracle database user name.

Cannot connect to the Oracle database.

See:

Also:

  • Check if the Oracle Database needs to be restarted.

  • Check the network status.

Cache administration user ID or password is not set (when trying to create AWT or cache groups with autorefresh).

See Set Cache Administration User Name and Password.

Data type mapping is unsupported.

See Unsupported Data Type Mapping.

Nullability setting in the Oracle database is different.

See Null Constraint Does Not Match Oracle Database.

Primary key in root table is not specified.

The root table of a cache group must have a primary key. See Defining Cache Groups in the Oracle TimesTen In-Memory Database Cache Guide.