txt文本数据数据载入oracle
2017-02-16 11:05:25 作者:MangoCool 来源:MangoCool
创建控制文件label.ctl:
cat > label.ctl
LOAD DATA // 载入数据
CHARACTERSET UTF8 // 设置编码,对应数据库编码,否则乱码
INFILE '/home/mangocool/CMBI903170111001001.txt' // 源数据文本
truncate // 删除旧记录,替换成新装载的记录
INTO TABLE DIM.DIM_ZB_LABEL // Oracle数据表名
FIELDS terminated by '|' // 文本数据字段分隔符
trailing nullcols // 允许文本数据字段为空
(
label_code ,
label_name,
label_level,
first_label_code,
first_label_name,
two_label_code,
two_label_name,
three_label_code,
three_label_name,
four_label_code,
four_label_name,
five_label_code,
five_label_name,
six_label_code,
six_label_name
)
执行入库命令:
sqlldr userid=用户/密码@数据库名 control='/home/mangocool/label.ctl' log='/home/mangocool/label.log' direct=true
分享: