升级20120605 _迁移_翻译表的迁移

在对数据库字典比如MAXOBJECTCFG 表迁移的时候，

MAXOBJECTCFG.description 在后台显示为'~NULL~',迁移到目标数据库的时候，显示的也是为'~NULL~'，这是不够的，还需要将翻译表L_MAXOBJECTCFG的信息也迁移过去。

 

MAXOBJECTCFG.MAXOBJECTID  与L_MAXOBJECTCFG.OWNERID 是一一对应的 。

方法：

在源数据库生成以下脚本（导出并做一定的处理） ，在目标数据库运行脚本。

select 'l_maxobjectcfgseq.nextval' l_maxobjectcfgid,
       t.langcode,
       t.description,
       '(select maxobjectid from maxobjectcfg   where objectname=''' ||
       a.objectname || ''')' ownerid

  from L_MAXOBJECTCFG t, maxobjectcfg a
 where t.ownerid = a.maxobjectid
   and t.ownerid in (select a.maxobjectid
                       from maxobjectcfg a
                      where a.objectname in ('MATRECVIEW',
                                             'JSITEMRETURN',
                                             'ZNWFORG',
                                             'FIXEDASSETLINE',
                                             'ZN_EQOPEN',
                                             'FIXEDASSET',
                                             'ENQUIRY',
                                             'GDZCXXBG',
                                             'GDZCTZJH',
                                             'PREWORKORDER',
                                             'DHDJBILL',
                                             'THDJBILL',
                                             'ZN_LOGOUT',
                                             'PREWOLINE',
                                             'RCKHB',
                                             'RCKHLINE',
                                             'EQREDEPLOY',
                                             'ZN_TZZYZHJ',
                                             'ZN_ZNTOTAL',
                                             'ZN_EXT_MT',
                                             'ZN_GQYB',
                                             'ZN_ELFAULT',
                                             'ZN_GREASE',
                                             'ZN_EQLEASE',
                                             'ACCIDENT',
                                             'PRORECTIFICATION',
                                             'ZN_ASSET_MT',
                                             'SPECEQUIPMENT',
                                             'ZN_RCWX',
                                             'ZN_EQSTOREUP',
                                             'ZN_SETM',
                                             'ZN_INVESPLAN',
                                             'ZN_HOURSE',
                                             'ZN_LAND',
                                             'ZN_MAINING',
                                             'ZN_FIXASSETLINE',
                                             'FIXASSETDP',
                                             'GDZCCZEQUIPMENT',
                                             'GDZCCZHOURSE',
                                             'GDZCDBHOURSE',
                                             'ZN_FIXASSETOR',
                                             'GDZCBFEQUIPMENT',
                                             'ZN_OILLING',
                                             'ZN_LLD',
                                             'ZNZCJDE',
                                             'ZNZCJLINE',
                                             'ZN_EQRECEIVE'))