oracle ctl 文件格式（追加数据）

--
-- Generated by OCIULDR
--
OPTIONS(BINDSIZE=8388608,READSIZE=8388608,ERRORS=-1,ROWS=50000)
LOAD DATA CHARACTERSET AL32UTF8
INFILE 'T_0101001.dat'
APPEND INTO TABLE T_0101001
FIELDS TERMINATED BY X'2c' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
  PROVIDER_ID CHAR(20),
  CUSTOME_ID CHAR(20),
  IS_PERSONAL CHAR(1),
  REAL_NAME CHAR(40),
  SEX CHAR(1),
  NATION_ID CHAR(3),
  AREA_ID CHAR(3),
  CARD_TYPE CHAR(1),
  CARD_NUMBER CHAR(20),
  BIRTHDAY CHAR(8),
  INCOME_ID CHAR(1),
  JOB_ID CHAR(2),
  EDUCATION CHAR(1),
  MOBILE_NUMBER CHAR(50),
  TELEPHONE CHAR(20),
  MAIL_ADDRESS CHAR(200),
  ZIP_CODE CHAR(10),
  ME_INFO CHAR(1000),
  PHOTO CHAR(100),
  DB_CREATE_BIZ_DAY DATE "YYYY-MM-DD HH24:MI:SS",
  DB_UPDATE_BIZ_DAY DATE "YYYY-MM-DD HH24:MI:SS",
  DB_CREATE_USER_ID CHAR(20),
  DB_UPDATE_USER_ID CHAR(20),
  DB_CREATE_PROG_ID CHAR(10),
  DB_UPDATE_PROG_ID CHAR(10),
  DB_CREATE_SYS_TIME DATE "YYYY-MM-DD HH24:MI:SS",
  DB_UPDATE_SYS_TIME DATE "YYYY-MM-DD HH24:MI:SS"
)

转载于:https://www.cnblogs.com/dkon/archive/2008/03/04/1089905.html