TT-05120
No matching unique index with not null columns, unique key constraint with not null columns, or primary key constraint on table table_name, cache operations are restricted
Cause
TimesTen cannot find a primary key or a unique NOT NULL index on the Oracle database to match the cache table's primary key.
Action
See Cache Groups and Cache Tables in Oracle TimesTen In-Memory Database Cache Guide for directions on how the Oracle database table must be created to be used as a cache table.
Additional Information
The cache group is created. However, the cache group operations are restricted to full cache group LOAD CACHE GROUP, UNLOAD CACHE GROUP and MERGE operations.
TT-05120
No matching unique index with not null columns, unique key constraint with not null columns, or primary key constraint on table table_name, cache operations are restricted
Cause
TimesTen cannot find a primary key or a unique NOT NULL index on the Oracle database to match the cache table's primary key.
Action
See Cache Groups and Cache Tables in Oracle TimesTen In-Memory Database Cache Guide for directions on how the Oracle database table must be created to be used as a cache table.
Additional Information
The cache group is created. However, the cache group operations are restricted to full cache group LOAD CACHE GROUP, UNLOAD CACHE GROUP and MERGE operations.
TT-05120
No matching unique index with not null columns, unique key constraint with not null columns, or primary key constraint on table table_name, cache operations are restricted
Cause
TimesTen cannot find a primary key or a unique NOT NULL index on the Oracle database to match the cache table's primary key.
Action
See Cache groups and cache tables in the Oracle TimesTen In-Memory Database Cache Guide for directions on how the Oracle database table must be created to be used as a cache table.
Additional Information
The cache group is created. However, the cache group operations are restricted to full cache group LOAD CACHE GROUP, UNLOAD CACHE GROUP and MERGE operations.
