sqlloader 命令
sqlldr userid=(user)/(pass)@oracle_id control=aaa.ctl log=bbb.log bad=ccc.bad data=ddd.dat
aaa.ctl内容如下
load data INFILE 'ddd.dat'
truncate
INTO TABLE EEETBL
trailing nullcols
(
AAA position(6:10) char(5),
BBB position(11:13) integer external,
CCC position(6:10) decimal external,
DDD SYSDATE,
DDD constant 'pppddd'
)
bbb.ctl内容如下
load data characterset JA16EUC
append
INTO TABLE EEETBL
fields terminated by","
trailing nullcols
(
AAA,
BBB,
CCC,
DDD SYSDATE,
DDD constant 'pppddd'
)