mysql 导入unl文件_Informix和Oracel数据库导入UNL数据

Oracle导入UNL数据

$1/$2@$3  用户名密码数据库名

1、loadunl.sh文件

##模板表部分数据(tap_gen_template)

sqlldr userid=$1/$2@$3control= ./tap_gen_template.ctl data= ./tap_gen_template.unl ;

2、tap_gen_template.ctl

LOAD DATA CHARACTERSET ZHS16GBK

INFILE 'tap_gen_template.unl'

BADFILE 'tap_gen_template.bad'

APPEND INTO TABLE tap_gen_template

FIELDS TERMINATED BY '|' optionally enclosed by '"'

TRAILING   NULLCOLS

(TEMPLATEID,NAME char(1000),TEMPLATEOWNERID,SHAREDSET,USERID char(1000),REGION_ID,CREATIONTIME "my_to_date(:CREATIONTIME)",LASTUPDATEDTIME "my_to_date

(:LASTUPDATEDTIME)",LASTUPDATEDUSERID char(1000),AUTO,AUTORUNTIME char(1000),AUTORUNCYCLE,DATASOURCE,SOURCETEMPLATEID,SUM_LEVEL,SUMLEVELEXPRESS,DESCRIPTION char

(1000),THEMEID,NETYPECODE,TEMPLATECATEGORYID,PATHNODEID,NEFILTER,TIMEF