1、编写命令脚本(.ctl格式)
LOAD DATA
INFILE '需导入的数据路径'
APPEND INTO TABLE USER_COST
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
字段名,
字段名,
...
)
2、在dos窗口输入:sqlldr 用户/密码 control=脚本路径
例如:sqlldr dm/dm control=C:UsersAdministratorDesktop estuser_info.ctl