Shulou(Shulou.com)06/01 Report--

If the table field names on the source side and the target side are inconsistent, the definition file should be used to solve the problem. The following steps are used.

Target generation definition file

1. Vi/goldengate/ogg12/ggs/dirprm/ver_def_tgt.prm

DEFSFILE /goldengate/ogg12/ggs/dirdef/ver_def_tgt.def

USERID ggs, PASSWORD xxxxx

table scott.t1;

2. Defgen paramfile /goldengate/ogg12/ggs/dirprm/ver_def_tgt.prm

3. Copy definition file ver_def_tgt.def to copy library

scp /goldengate/ogg12/ggs/dirdef/ver_def_tgt.def oracle@192.168.0.3:/goldengate/ogg12/ggs/dirdef

4. Add parameters to source-side grab process

edit params exta

TARGETDEFS/goldengate/ogg12/ggs/dirdef/ver_def_tgt.def

Note: If the users of the synchronization table on the source side and the target side are different, the synchronization table must be synchronized at the source side.

TABLE scott.t1 ,TARGET hr.t1,colmap(usefaults); hr colmap(usefaults) for the target user to prevent garbled characters after synchronization. At the same time, the table name of the transmission process should also be changed to the table name of the target user.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.