copy from oracle document "Utilities"Example 7-16 Loading Data Using BFILEs: Filename and Directory Name Specified DynamicallyControl File Contents
LOAD DATA
INFILE sample.dat
INTO TABLE planets
FIELDS TERMINATED BY ’,’ OPTIONALLY ENCLOSED BY ’"’
(pl_id NUMBER(4),
pl_name CHAR(20),
fname FILLER CHAR(30),
dname FILLER CHAR(20),
pl_pict BFILE(dname, fname) )Datafile (sample.dat)
1, Mercury, mercury.jpeg, scott_dir1,
2, Venus, venus.jpeg, scott_dir1,
3, Earth, earth.jpeg, scott_dir2,
LOAD DATA
INFILE sample.dat
INTO TABLE planets
FIELDS TERMINATED BY ’,’ OPTIONALLY ENCLOSED BY ’"’
(pl_id NUMBER(4),
pl_name CHAR(20),
fname FILLER CHAR(30),
dname FILLER CHAR(20),
pl_pict BFILE(dname, fname) )Datafile (sample.dat)
1, Mercury, mercury.jpeg, scott_dir1,
2, Venus, venus.jpeg, scott_dir1,
3, Earth, earth.jpeg, scott_dir2,
我的问题是:
1。控制文件合数据文件都再一个文件中(这不存在问题)
2。有一个blob字段,且这个字段里的内容要存二进制。问题是如果用二进制的,则在这些二进制流中有可能出现10(换行),从而sqlldr将把10解释成换行,这将出错。这么办?