使用sqlldr导入GPS数据含有clob字段和双引号

来源：互联网发布：手机淘宝怎么看直播间编辑：程序博客网时间：2024/05/15 23:12

load data
characterset AL32UTF8
INFILE 'E:\HIS_TAXI_TRACK_HIS_TAXI_20150507.txt'
append
into table taxi_gps_20150507
fields terminated by ','

(ID TERMINATED BY "," OPTIONALLY ENCLOSED BY '"',GPSID TERMINATED BY "," OPTIONALLY ENCLOSED BY '"',DDATE TERMINATED BY "," OPTIONALLY ENCLOSED BY '"',TRACK char(1000000000) TERMINATED BY "," OPTIONALLY ENCLOSED BY '"')

cmd输入sqlldr userid=XXX/XXX@XXX control='E:\taxi_gps_20150525.ctl' log='E:\taxi_gps_20150525.log' skip=1 readsize=10485760

PL/SQL 字符变量可以很长，但数据库中char 类型的长度只有2000字节。

所以我们不能将大于2000字节的字符插入到数据库的字符列中。但我们可以将任何的char(N) 的值插入到long 或是clob 中。但我们不能将一个大于32767的字节的long赋给一个char（N）变量，这个因为在char 的maximum_size 为 32767 .

0 0