oracle csn,使用logdump 来查看CSN的值，注意符号

GGSCI (nw3-rac1.ht8888.ht3)

87> view param ext1

EXTRACT ext1EXTTRAIL ./dirdat/bjtranlogoptions dblogreaderUSERID

ogg@orcl_beq, PASSWORD oggWILDCARDRESOLVE

DYNAMICDYNAMICRESOLUTIONTABLE tianbaobao.tianbaobao,

TOKENS(TK-CSN=@getenv("TRANSACTION","CSN"));

GGSCI

(nw3-rac1.ht8888.ht3) 90> start

ext1

Sending START request to MANAGER ...EXTRACT EXT1 starting

GGSCI

(nw3-rac1.ht8888.ht3) 91> info

all

Program

Status

Group

Lag at Chkpt  Time Since Chkpt

MANAGER

RUNNING

EXTRACT

ABENDED

EXT1

unknown

00:00:10

EXTRACT

STOPPED

PMP1

00:00:00

09:23:27

GGSCI

(nw3-rac1.ht8888.ht3) 100> view report

ext1

2015-03-01 16:23:23

INFO

OGG-01298  Column function diagnostic message:

could not find column "TRANSACTION".

修改成单引号试试

GGSCI

(nw3-rac1.ht8888.ht3) 102> view param

ext1

EXTRACT ext1EXTTRAIL ./dirdat/bjtranlogoptions dblogreaderUSERID

ogg@orcl_beq, PASSWORD oggWILDCARDRESOLVE

DYNAMICDYNAMICRESOLUTIONTABLE tianbaobao.tianbaobao,

TOKENS(TK-CSN=@getenv('TRANSACTION','CSN'));

GGSCI

(nw3-rac1.ht8888.ht3) 104> info

all

Program

Status

Group

Lag at Chkpt  Time Since Chkpt

MANAGER

RUNNING

EXTRACT

RUNNING

EXT1

unknown

00:00:05

EXTRACT

STOPPED

PMP1

00:00:00

09:25:59

GGSCI

(nw3-rac1.ht8888.ht3) 105> view report

ext1

2015-03-01 16:25:01

INFO

OGG-06507  MAPTABLE resolved (entry

tianbaobao.tianbaobao): TABLE "TIANBAOBAO"."TIANBAOBAO",

TOKENS(TK-CSN=@getenv('TRANSACTION','CSN')).

注：11g使用双引号，12c使用单引号。