楼主对dts比较熟为何不用,也可以用pb
解决方案 »
- 请问怎么远程连接数据库
- sql 空值问题
- 求SOL写法并优化之(数据行较多)
- 求救!!!无法删除oracle资料档案库
- 实在找不到错误
- 急问,怎么把oracle数据导出成txt文档,或者xls文档?
- 有没有低级一点的入门书或者是电子书下载啊?
- 在SQL PLUS的过程中怎么给表插入记录?
- 感谢以下朋友:bzszp(SongZip), blue__star(蓝色沸点) ,mimimi(开心果) , jlandzpa(ORA-00600),barrytyh(海阔天空)
- 请指教容易造成监听崩溃的原因
- 一句sql语句的条件判断,简单问题!
- 通过在MSSQL中定义用户数据类型是否有助于以后将表移到Oracle来
sqlldr还是比较简单的
LOAD DATA
INFILE 'MOT_TCY_CONSUMERS.030616'
BADFILE 'BAD_MOT_TCY_CONSUMERS.030616'
DISCARDFILE 'DIS_MOT_TCY_CONSUMERS.030616'
append
INTO TABLE SIEBEL.MOT_CONSUMERS1
TRAILING NULLCOLS
(
CONSUMER_URN CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
TCY_U_NUMBER CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
FAMILY_NAME CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
GIVEN_NAME CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
GENDER CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
BIRTH_DATE DATE "dd-mm-yyyy" TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
ID_TYPE CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
ID_NUMBER CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
OCCUPATION CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
EDUCATION CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
ADDRESS_LINE CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
POSTAL_CODE CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
CITY CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
PROVINCE CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
COUNTRY CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
HOME_PHONE_COUNTRY CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
HOME_PHONE_AREA CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
HOME_PHONE_NUMBER CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
WORK_PHONE_COUNTRY CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
WORK_PHONE_AREA CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
WORK_PHONE_NUMBER CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
MOBILE_PHONE_COUNTRY CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
MOBILE_PHONE_NUMBER CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
EMAIL_ADDRESS CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
GONEAWAY_FLAG CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
LAST_UPDATED_DATE DATE "dd-mm-yyyy hh24:mi:ss" TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"',
ATTRIBUTE1 CHAR TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
)
只是要做两种方法,看哪个好罢了
用dts还要装sql server,用pb也要pb的dll
哪位给点sqlldr的详细资料