首页 > 代码库 > oracle使用sqlldr(有sequence)导入数据

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

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