本文详细介绍了如何使用SQL数据加载工具（SQLldr）将外部文件数据导入数据库，并讨论了数据库中字符类型长度限制的问题，特别关注了如何处理超过2000字节的长字符串数据。
load data
characterset AL32UTF8
INFILE 'E:\HIS_TAXI_TRACK_HIS_TAXI_20150507.txt'
append
into table taxi_gps_20150507
fields terminated by ','
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 .
扫一扫
3116
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
