veridata如何得到out of Out-Of-Sync
用veridata对比数据后，可以在网页上看到那些行是不匹配的。如果我想手动写纠正这些数据，现在只能从网页上拷贝一个一个值用sql纠正。
有没有谁有好的方法可以批量处理的，速度可以快点 How to run Veridata jobs from command line
/app/oggver/Oracle_GoldenGate_Veridata/server/bin
Compare the whole group
$ ./vericom -j myjob
Connecting to: localhost:4150
Run ID: (1019, 0, 0)
REMARK: Myjob is your job name.
Compare Only one table
$ ./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
$ ./vericom -j myjob -g mygroup -c TNOKEY=TNOKEY -pS mypartition1 -pT mypartition1
Or you can direct write the sql here:
$ ./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.
Maclean Liu(刘相兵 发表于 2013-4-19 11:23 static/image/common/back.gif
How to run Veridata jobs from command line
/app/oggver/Oracle_GoldenGate_Veridata/server/bin
Compare ...
使用命令行对比后，那些不一致的数据时在哪里看呢。还是在网页上？
页:
[1]