sqlldr默认字符串最大长度
1、sqlldr入库对字段长度进行的限制,默认是255。如果超出了255应该怎么办呢?
很简单:直接在列名后面修改默认长度,如:地址字段长度300
address char(300)
2、sqlldr入clob字段也可以采用修改默认长度的方法如:article char(20000)
Ctl文件(TRUNCATE)直接覆盖原表插入
OPTIONS (SILENT=(ALL),DIRECT=TRUE) UNRECOVERABLE LOAD DATA INFILE 'D:/area_data_temp/BSC/bsc.csv' TRUNCATE INTO TABLE TB_BSC_INFO FIELDS TERMINATED BY '`' TRAILING NULLCOLS (BSC_NAME,PROVINCE,CITY,SGSN char(1024),MACHINE_ROOM,IP,COVER_RANGE,PRODUCT_FACTORY,LIFE_STATE,CRT_TIME "sysdate",BSC_ID SEQUENCE(MAX,1)) |
Ctl文件(APPEND)在原表的基础上追加
OPTIONS (SILENT=(ALL),DIRECT=TRUE,PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=TRUE) UNRECOVERABLE LOAD DATA INFILE 'D:/area_data_temp/CELL/cell.csv' APPEND INTO TABLE TB_CELL_INFO FIELDS TERMINATED BY '`' TRAILING NULLCOLS (CELL_NAME,LAC,CI,LIFE_STATE,CRT_TIME "sysdate",CELL_ID SEQUENCE(MAX,1)) |