现象:客户gg做extract时报错ogg-00053ogg-00053: no extraction maps specifiedcause: there are no table parameters in the e
现象:客户gg做extract时报错ogg-00053
ogg-00053: no extraction maps specified
cause: there are no table parameters in the extract parameter file to specify
source tables for which to capture data.
action: add one or more table parameters to the extract parameter file.
ggsci (joadbtest01) 3>add extract ext2, sourceistable
ggsci (joadbtest01) 3>edit params ext2
extract ext2
userid goldengate,password goldengate
rmthost 10.0.15.107 , mgrport 7839
rmttask replicat, group initrep
table newolm.*;
分析:
经过查看newolm下没有表对象。
ggsci (joadbtest01) 3> info trandata newolm.*
error: no viable tables matched specification.
ggsci (joadbtest01) 4>
sql> select count(*) from dba_tables where owner='newolm'
count(*)
----------
0
解决方法:
对于不存在任何表对象的schema,,gg做extract时会报错ogg-00053。