17,377
社区成员
发帖
与我相关
我的任务
分享
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,
options (rows=40000,bindsize=209714452,readsize=209714452,skip_index_maintenance=true)
load data
infile '/opt/oracle/cbiz128.txt'
append into table T_BIZ
fields terminated by ','
(BIZID integer,CUSTID integer,TCOUNT integer,SENDDATE date 'yyyy-mm-dd hh24:mi:ss',SCHDATE date 'yyyy-mm-dd hh24:mi:ss')
就会报错显示为 Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
BIZID FIRST 4 INTEGER
CUSTID NEXT 4 INTEGER
TCOUNT NEXT 4 INTEGER
SENDDATE NEXT * , DATE yyyy-mm-dd hh24:mi:ss
SCHDATE NEXT * , DATE yyyy-mm-dd hh24:mi:ss
Record 1: Rejected - Error on table T_BIZ, column SENDDATE.
ORA-01840: input value not long enough for date format