Oracle導(dǎo)入U(xiǎn)NL數(shù)據(jù)

$1/$2@$3? 用戶名密碼數(shù)據(jù)庫名

1、loadunl.sh文件

##模板表部分?jǐn)?shù)據(jù)(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,TIMEFILTER,ISNEWVERSION,TECHNOLOGY,VENDORID,NEGRANULITY)

3、 tap_gen_template.unl

1110078|GSM_參數(shù)_母板_(愛立信)語音優(yōu)先_NEW|0|0|63c26d7f-6e39-40b0-9526-94c58f2d77ca|-1|2012-4-11 15:35:36|2012-4-11 15:35:36|63c26d7f-6e39-40b0-9526-

94c58f2d77ca|0||0|0|-1|0|Detail||6|0|5|61|||1|GSM|1|300|

1110065|GSM_參數(shù)_母板_(華為)語音優(yōu)先_NEW|0|0|63c26d7f-6e39-40b0-9526-94c58f2d77ca|-1|2012-4-11 15:35:36|2012-4-11 15:35:36|63c26d7f-6e39-40b0-9526-

94c58f2d77ca|0||0|0|-1|1|Detail||6|0|5|61|||1|GSM|8|300|

1110064|GSM_參數(shù)_母板_(卡特)語音優(yōu)先_NEW|0|0|63c26d7f-6e39-40b0-9526-94c58f2d77ca|-1|2012-4-11 15:35:36|2012-4-11 15:35:36|63c26d7f-6e39-40b0-9526-

94c58f2d77ca|0||0|0|-1|1|Detail||6|0|5|61|||1|GSM|0|300|

Informix導(dǎo)入U(xiǎn)NL數(shù)據(jù)

1、loadunl.sql

load from ./tap_gen_template.unl insert into tap_gen_template;

2、1110078|GSM_參數(shù)_母板_(愛立信)語音優(yōu)先_NEW|0|0|63c26d7f-6e39-40b0-9526-94c58f2d77ca|-1|2012-4-11 15:35:36|2012-4-11 15:35:36|63c26d7f-6e39-40b0-9526-

94c58f2d77ca|0||0|0|-1|0|Detail||6|0|5|61|||1|GSM|1|300|

1110065|GSM_參數(shù)_母板_(華為)語音優(yōu)先_NEW|0|0|63c26d7f-6e39-40b0-9526-94c58f2d77ca|-1|2012-4-11 15:35:36|2012-4-11 15:35:36|63c26d7f-6e39-40b0-9526-

94c58f2d77ca|0||0|0|-1|1|Detail||6|0|5|61|||1|GSM|8|300|

1110064|GSM_參數(shù)_母板_(卡特)語音優(yōu)先_NEW|0|0|63c26d7f-6e39-40b0-9526-94c58f2d77ca|-1|2012-4-11 15:35:36|2012-4-11 15:35:36|63c26d7f-6e39-40b0-9526-

94c58f2d77ca|0||0|0|-1|1|Detail||6|0|5|61|||1|GSM|0|300|

1110079|GSM_參數(shù)_母板_(摩托羅拉)語音優(yōu)先_NEW|0|0|63c26d7f-6e39-40b0-9526-94c58f2d77ca|-1|2012-4-11 15:35:36|2012-4-11 15:35:36|63c26d7f-6e39-40b0-9526-

94c58f2d77ca|0||0|0|-1|-100|Detail||6|0|5|61|||1|GSM|3|300|

總結(jié)

以上是生活随笔為你收集整理的mysql 导入unl文件_Informix和Oracel数据库导入UNL数据的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。