sqlldr用法

sqlldr user/pwd@serviceName control=load.ctl

load.ctl内容如下：

load data
infile 'C:\Documents and Settings\Administrator\桌面\数据文件.txt'
append into table tableName //append 或者 replace
fields terminated by ';' //分隔符
(
	EMAIL CHAR,
	GENDER CHAR,
	AGE CHAR
)

---