- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
2#
发表于 2013-4-19 11:23:02
How to run Veridata jobs from command line
/app/oggver/Oracle_GoldenGate_Veridata/server/bin
Compare the whole group
[oracle@dbsrv1 bin]$ ./vericom -j myjob
Connecting to: localhost:4150
Run ID: (1019, 0, 0)
REMARK: Myjob is your job name.
Compare Only one table
[oracle@dbsrv1 bin]$ ./vericom -j myjob -g mygroup -c TNOKEY=TNOKEY
Connecting to: localhost:4150
Run ID: (1021, 0, 0)
REMARK: Myjob is your job name, mygroup is your compare group name, tnokey=tnokey is your compare pair name.
Compare only a partition of a table
[oracle@dbsrv1 bin]$ ./vericom -j myjob -g mygroup -c TNOKEY=TNOKEY -pS mypartition1 -pT mypartition1
Or you can direct write the sql here:
[oracle@dbsrv1 bin]$ ./vericom -j myjob -g mygroup -c TNOKEY=TNOKEY -pq name=’a’
This will apply the query to both source and target. Please refer to Veridata admin guide for more command line help.
|
|