sqlldr导入大量数据

ctl 文件语句

OPTIONS (skip=1,rows=500)
load data
infile 'D:\tmp\13.txt'
append into table RMS_BZ_CELL fields terminated by ','
trailing nullcols(INT_ID INTEGER,CITY_ID,IS_WRONG,WRONG_INFO,ZH_LABEL,ADDR_TYPE,GRADE_ADD,COUNTY_ID,PROVINCE_ID,CUID,TIME_STAMP,MODIFY_TIME,STATEFLAG,CREATOR,CREAT_TIME,MODIFIER,RELATED_ROAD_ID INTEGER,HOUSE_NUMBER_ID INTEGER,RELATED_ADDRESS_ID INTEGER,UP_ADDRESS,GRADE_ADD_REMARK)
 

建表语句

create table  RMS_BZ_CELL
(
  int_id             INTEGER not null,
  city_id            INTEGER not null,
  is_wrong           INTEGER,
  wrong_info         VARCHAR2(1024),
  zh_label           VARCHAR2(255),
  addr_type          VARCHAR2(255),
  grade_add          INTEGER,
  county_id          INTEGER,
  province_id        INTEGER,
  cuid               VARCHAR2(255),
  time_stamp         TIMESTAMP(6),
  modify_time        TIMESTAMP(6),
  stateflag          INTEGER,
  creator            VARCHAR2(255),
  creat_time         TIMESTAMP(6),
  modifier           VARCHAR2(255),
  related_road_id    INTEGER,
  house_number_id    INTEGER,
  related_address_id VARCHAR2(500),
  up_address         INTEGER,
  grade_add_remark   INTEGER
);

 

cmd执行命令

sqlldr userid=username/password@servername  control=d:\tmp\input.ctl log=d:\tmp\input.log