1、编写ctl文件 LHTEST:
LOAD DATA
INFILE '/usr/test/aaa.txt'
BADFILE './LHTEST.BAD'
DISCARDFILE './LHTEST.DSC'
APPEND INTO TABLE LC.LHTEST
Fields terminated by ";"
(
ID,
TIME "to_char(sysdate, 'yyyy-MM-dd HH24:mi:ss')",
NAME constant "test"
)
2、准备文件 aaa.txt ,放置linux中的 /usr/test目录中,其分割符号为“;”,示例数据如下:
4DF61BB504823008E050A8C04C0F283C;2017-04-27 11:19:00;lh
4DF6FC05B9D188BDE050A8C04C0F4237;2017-04-27 11:19:00;lh
4DF6F4DE42A161D8E050A8C04C0F4158;2017-04-27 11:19:00;lh
3、在/usr/test目录中输入命令:
sqlldr userid=lc/lc@xxxx:1521/xx control=LHTEST.ctl