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
)