使用SQLLDR把Sybase中的数据导到Oracle中

1.自增主键

load data
infile 'sgsnlist'
truncate into table SGSNLIST
fields 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 " "