开发给了dat文件,让帮sqlldr导入,但无ctl参考。
传到linux解压后看到的内容如下:用head/more/cat看不到分隔字符,vi可以看到^E,但控制文件用以下方式导入都失败,应该用什么特殊字符处理?
使用fields terminated by '0x05'
fields terminated by '^E '
ue打开看到是
在ue里查看二进制模式是05
处理办法:
1.ctl内容如下:
load data
infile '1.txt'
infile '2.txt'
append into table MBO_FUSE_PAIZHAO_20200113fields terminated by '05'缺少X
FIELDS TERMINATED BY x'05'
TRAILING NULLCOLS
(
latn_name ,
latn_ppm_code ,
region_name
)
执行导入
sqlldr xx/xxx control='1.ctl' readsize=65535000 bindsize=65535000 direct=Y
SQL*Loader: Release 11.2.0.4.0 - Production on Wed Nov 18 12:57:50 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Load completed - logical record count 1812598.
相关参考:
http://blog.sina.com.cn/s/blog_61c006ea0100l2rt.html