在oracle中直接指定字段为primary key，建立read only cache group是能成功的，timesten的文档中基本都是这个例子
oracle：

SQL> create table test_jt ( id number(9) primary key, birth date);

Table created


TimesTen(v7)：
Command> CREATE READONLY CACHE GROUP test_jt_mem
> AUTOREFRESH INTERVAL 5 SECONDS
> FROM test_jt
> (
> id number(9) primary key,
> birth date
> );

但是在实际生产中，经常是单独建立unique index，但是在这种情况下，建立readonly cache group失败
oracle :
SQL> create table test_jt (id number(9), birth date);

Table created

SQL>  create unique index test_jt_id_idx on test_jt(id);

Index created

TimesTen(v7)：
Command> CREATE READONLY CACHE GROUP test_jt_mem
> AUTOREFRESH INTERVAL 5 SECONDS
> FROM test_jt
> (
> id number(9),
> birth date);
8213: Cache group tables must have a primary key.
The command failed.

Command> CREATE READONLY CACHE GROUP test_jt_mem
> AUTOREFRESH INTERVAL 5 SECONDS
> FROM test_jt
> (
> id number(9) primary key,
> birth date
> );
5120: No matching unique index or unique/primary key constraint on table BILLING.TEST_JT, cache operations are restricted
5168: Restricted cache groups are deprecated
5126: A system managed cache group cannot contain non-standard column type mapping
The command failed.

请问高手，应该怎么操作啊，谢谢

搞定了，需要把建索引的字段显示声明为NOT NULL

是的.我今天也在测试.直接按照oracle的文档,就可以了.