1.自增主键
load datainfile 'sgsnlist'truncate into table SGSNLISTfields terminated by ","trailing nullcols(SGSNINDEX sequence(max,1),SGSNADDRESS,GGSNHOST)
2.日期格式转换
STARTTIME "TO_DATE(TO_CHAR(TO_TIMESTAMP(:STARTTIME, 'MON-DD-YYYY HH:MI:SS:FF AM','NLS_DATE_LANGUAGE=AMERICAN'),'MON DD YYYY HH24:MI:SS'),'MON DD YYYY HH24:MI:SS')",
3.跳过字段
catalog FILLER
4.设置字段默认值
lastusetime " "