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