SQLLOADER 命令小结 201406

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'

)