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

命令：

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

username  用户名

password  密码

database  数据库实例

filepath    ctl文件的物理路径

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

文件：

load datainfile *append into table [TABLENAME]fields terminated by ","trailing nullcols([ID] sequence(1,1),  [COL1],  [COL2],  [COL3],  [COL4],  [COL5],  [COL6])Begindatax, xx, xxx, xxxx, xxxxx, xxxxxxa, aa, aaa, aaaa, aaaaa, aaaaaa

tablename  表名

id  主键

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