- 论坛徽章:
- 0
|
有个sqlldr导入时间常量的问题,请教下各位,希望各位多多赐教,感谢!
要求:
1、表t_p_h24reqstat 有4列,statdate是data类型;文本'2013-08-14-00.txt‘里面有三列(没有statdate字段);
2、将2013-08-14-00.txt导入表t_p_h24reqstat 中,导入过程中自动补全statdate字段;
控制文件:
load data infile '2013-08-14-00.txt'
append in
to table t_p_h24reqstat fields terminated by "|"
(STATDATE constant "2013-08-15 19:30:00",requestid,h0c,h0t)
执行上面ctrl导入时报statdate字段格式错误,修改为以下还是不行:
(STATDATE DATE"yyyy-mm-dd hh24:mi:ss" constant "2013-08-15 19:30:00",requestid,h0c,h0t)
SQL*Loader-350: Syntax error at line 2.
Expecting "," or ")", found keyword constant.
(STATDATE DATE"yyyy-mm-dd hh24:mi:ss" constant "2013-08-15 19:30:00",R
|
|