命令:
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 字段名