Checkpoint table有两种类型:主表和辅助表。主表根据用户定义名称来来创建,辅助表会自动创建。辅助表就是transaction table。名称是checkpoint table名上加_LOX。
SQL> conn ogg/ogg Connected. SQL> SQL> select table_name from user_tables; TABLE_NAME ------------------------------ CKKPOINT_LOX CKKPOINT SQL> |
Checkpoint table配置方法:
(1):在./GLOBALS文件里添加checkpoint 表名
GGSCI(suys1) 1> view param ./GLOBALS
ggschema ogg checkpointtableogg.checkpointtab GGSCI (suys1) 2> |
(2):连上DB,创建checkpoint表
GGSCI(suys1) 85> dblogin userid ogg, password ogg Successfullylogged into database.
GGSCI(suys1) 86> add checkpointtable ogg. checkpointtab Successfully created checkpoint table ogg.checkpointtab. |
--生成这个检查点记录表
(3):验证
conn ggs/ SQL> select * from checkpoint; |