oracle使用sqlldr(有sequence)导入数据

命令：

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  字段名