TimesTen

create table test(a int
primary key,b char(10));

insert into test values(1,’aa’);
insert into test values(2,’bb’);
insert into test values(3,’cc’);
commit;

grant 相应的权限 to test;

create materialized view log on test;

create materialized view mv_test refresh fast on commit
enable query rewrite as select * from test;

SQL> select * from mv_test;   

A B
———-
1 aa
2 bb
3 cc

首先创建DataStore：

[ttcore]
Driver=/home/tt705/TimesTen/tt705/lib/libtten.so
DataStore=/home/tt705/TimesTen/tt705/info/ttcore
DatabaseCharacterSet=ZHS16GBK
PermSize=12
TempSize=12
UID=test
PWD=test
OracleID=orcl
OraclePWD=test

注意字符集要和Oracle中的一样。

ttisql ttcore

Command> call  ttcacheuidpwdset(’test’,'test’);

Command> CREATE USERMANAGED CACHE GROUP cg_mv_test from
> test.mv_test (a int primary key,b char(10));
Warning  5144:The cache group contains a Oracle materialized view, cache operations are restricted.

Command> load cache group cg_mv_test commit every 10 rows;
3 cache instances affected.

Command> select * from mv_test;
<1,aa        >
<2,bb        >
<3,cc        >
3 rows found.

SQL> insert into test values(4,’dd’);
1 row created.

SQL> commit;
Commit complete.

SQL> select * from mv_test;

A B
———-
1 aa
2 bb
3 cc
4 dd

Command> load cache
group cg_mv_test commit every 10 rows;
1 cache instance affected.
Command> select * from mv_test;
<1,aa        >
<2,bb        >
<3,cc        >
<4,dd        >
4 rows found.