load data
infile
'/opt/TestData/psbc/data/TestData/T98_INDPTY_TX_STAT.txt'
append into table T98_INDPTY_TX_STAT
fields terminated by " !"
(SUMM_DATE date 'yyyymmdd',STAT_ORG_ID
char(9),BIZ_TYPE_CD,CONFORM_INDPARTY_ID,PRODUCT_ID,CURRENCY_CD,TX_TYPE_CD,MON_ACCUM_TX_NUM,MON_ACCUM_TX_AMT,QUA_ACCUM_TX_AMT,QUA_ACCUM_TX_NUM,YR_ACCUM_TX_NUM,YR_ACCUM_TX_AMT,PROVINCE_CD,TXDATE
date 'yyyymmdd')
-----------------------------------------------------------------------------------------------
两种插入模式:
一种是利用sql的插入语句,而另一种则是直接格式化数据库的块;
sqlldr psbc/psbc control=/opt/impora/t1.ctl
直接加载的方式:绕过sql引擎和undo的生成,而且也不生成redo,这样做是最快的加载方式;
注:direct为直接加载
parallel为并行加载
sqlldr psbc/psbc control=/opt/impora/t1.ctl direct=true
parallel=true &
sqlldr psbc/psbc control=/opt/impora/t2.ctl direct=true
parallel=true &
sqlldr psbc/psbc control=/opt/impora/t3.ctl direct=true
parallel=true &
sqlldr psbc/psbc control=/opt/impora/t4.ctl direct=true
parallel=true &
------------------
sqlldr中不支持varchar2
oracle建表语句中varchar会自动改成varchar2