oracle数据库类型是varchar2(30)的,导入就是不对。Load data Infile '/var/test/tmp/DALLUSERRTMP.cvs' replace delete Into table KDCS_BROADBANDUSER (ID "KDCS_BROADBANDUSER_SEQ.NEXTVAL", ACCOUNT terminated by ',', BANDWIDTH terminated by ',', PROVINCE terminated by ',', CITY terminated by ',', CONNECTTYPE terminated by ',', ACCOUNTTYPE terminated by ',')
LOAD DATA INFILE 'r:/temp/a.txt' INTO TABLE cyx FIELDS TERMINATED BY ','
第1个字段为字符型
没有问题
Infile '/var/test/tmp/DALLUSERRTMP.cvs'
replace delete Into table KDCS_BROADBANDUSER
(ID "KDCS_BROADBANDUSER_SEQ.NEXTVAL",
ACCOUNT terminated by ',',
BANDWIDTH terminated by ',',
PROVINCE terminated by ',',
CITY terminated by ',',
CONNECTTYPE terminated by ',',
ACCOUNTTYPE terminated by ',')
02700428056,4M,71,0027,3,0
02700428788,4M,71,0027,3,0
02700428791,4M,71,0027,3,0
02700428793,4M,71,0027,3,0
CREATE TABLE "KDCS"."KDCS_BROADBANDUSER"
( "ID" NUMBER,
"ACCOUNT" VARCHAR2(30 BYTE),
"BANDWIDTH" VARCHAR2(30 BYTE),
"PROVINCE" VARCHAR2(30 BYTE),
"CITY" VARCHAR2(30 BYTE),
"CONNECTTYPE" NUMBER,
"ACCOUNTTYPE" NUMBER,)