1,执行如下命令
[dm7@monitor ~]$ vim /dm7/cndba.ctl
LOAD DATA
INFILE ‘/dm7/cndba.txt’
BADFILE ‘/dm7/cndba.txt’
INTO TABLE cndba
FIELDS ‘|’
(
C1 TERMINATED BY ’ ',
C2,
C3 DATE FORMAT ‘yyyy-mm-dd’
)
[dm7@monitor ~]$
2,[dm7@monitor ~]$ dmfldr userid=SYSDBA/dameng123 control=’/dm7/cndba.ctl’ log=’/dm7/cndba.log’
3,报数据库socket链接失败
4,发现设置的数据库不是默认的5236
5,修改命令[dm7@monitor ~]$ dmfldr userid=SYSDBA/dameng123@192.168.71.3:6236 control=’/dm7/cndba.ctl’ log=’/dm7/cndba.log’
6,执行成功。