命令:

sqlldr userid=[USERNAME]/[PASSWORD]@[DATABASE] control=[FILEPATH]

username 用户名

password 密码

database 实例

filepath ctl文件的物理路径

-----------------------------------------------------------------------

文件:

load data
infile *
append into table [TABLENAME]
fields terminated by ","
trailing nullcols
([ID] sequence(1,1),
  [COL1],
  [COL2],
  [COL3],
  [COL4],
  [COL5],
  [COL6])
Begindata
x, xx, xxx, xxxx, xxxxx, xxxxxx
a, aa, aaa, aaaa, aaaaa, aaaaaa

tablename 表名

id 主键

col1,2,3,4,5,6 字段名