发布时间：2014-03-25 17:27:51
投递进程添加TABLE HX_DJ.TEST2, TOKENS (TKN-COMMIT-TS = @GETENV ("GGHEADER", "COMMITTIMESTAMP") ...将数据提交时获取的时间戳存入变量 TKN-COMMIT-TS入库进程添加MAP hx_dj.test2, TARGET hx_dj.test2,colmap (usedefaults,DEAL_DATE=@token("TKN-COMMIT-TS"), ...获取变量值存入相应字段下面是（抽取，投递.........【阅读全文】
发布时间：2014-03-25 16:31:03
EXPDP按条件导出，将下面SQL语句的查询结果导出export ORACLE_SID=sidexpdp system/password parfile=/home/oracle/backup/02.par--执行SQLselect * from hx_ff.ff_ffkf a where substr(a.ssswjg_dm ,1,3) in ('137','237');select * from hx_ff.ff_kfgly a where substr(a.kfgly_dm ,1.........【阅读全文】
