给你一个控制文件的例子:LOAD DATA
INFILE 'attr_store.dat'
APPEND
INTO TABLE ds_attrstore
FIELDS TERMINATED BY X'ff'
trailing nullcols
(ENTRYID,ATTRNAME,ATTRSTYPE, ATTRVAL, ATTRKIND)
INFILE 'attr_store.dat'
APPEND
INTO TABLE ds_attrstore
FIELDS TERMINATED BY X'ff'
trailing nullcols
(ENTRYID,ATTRNAME,ATTRSTYPE, ATTRVAL, ATTRKIND)
http://www.chinaunix.net/jh/19/213795.html
所有的SQLLDR技巧都有