/var/job/sqluldr/sqluldr2.bin user=root/root@192.1111.1.111:5000/orcl query="select to_char(t.visit_time,'yyyy-mm-dd HH24:MI:ss'), t.source_code, t.product_id from tjt_download t where t.visit_time>=to_date('20130709','yyyymmdd') and t.visit_time<to_date('20130709','yyyymmdd')+1 and rownum<=10" field=#_# rows=2000000 batch=yes file="/var/job/data/tjt_download_%b.txt" charset=UTF8 log=+"/var/job/logs/sqluldr2.log"
- 1
- 2
- 3
- 4
前往页