MySQL database import to Oracle database

First, write a cmd script xx.cmd

sqlldr username/password control=xx.ctl errors=10000000 direct=y

Write a bat script again Xx.bat servicename is generally ORCL

sqlplus username/password@serviceName

To load the SQL

call xx.cmdsqlplus username/password@serviceName @xx.sql

Write a CTL file Xx.ctl

LOAD DATAINFILE ‘xx.txt‘ BADFILE ‘ismpbill.bad‘DISCARDFILE ‘ismpbill.dsc‘INTO TABLE "table1"APPENDFIELDS TERMINATED BY X‘09‘TRAILING NULLCOLS(column 1,column 2,column3)

Specify the delimiter, the field terminates at X ' 09 ' (very important), is a tab (tab), if separated by commas, X ' 09 ' is replaced with ', '

insert，为缺省方式，在数据装载开始时要求表为空append，在表中追加新记录replace，删除旧记录，替换成新装载的记录truncate，同上

BY ‘|‘

means the field terminates at ' | '

MySQL database import to Oracle database