日期:2014-05-17 浏览次数:21315 次
options (rows=40000,bindsize=209714452,readsize=209714452,skip_index_maintenance=true) load data infile '/opt/oracle/cbiz128.txt' append into table T_BIZ TRAILING NULLCOLS (BIZID integer TERMINATED BY ',', CUSTID integer TERMINATED BY ',', TCOUNT integer TERMINATED BY ',', SENDDATE date 'yyyy-mm-dd hh24:mi:ss' TERMINATED BY ',', SCHDATE date 'yyyy-mm-dd hh24:mi:ss' TERMINATED BY x '0A')
20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21, 20120120115648,88364,1000,2012-01-20 12:01:21,