oracle load重复数据,ORACLE 经常使用的命令工具-第六章:LOAD数据

第六章:LOAD数据

#t(H2{y]F0　　1.loading data using direct_load insert.^|Cu&Yx*c0

51Testing软件测试网ziH]/}#t

sql> insert /* append */ into emp nologging51Testing软件测试网%l$a,oUY]zb

51Testing软件测试网0V,MsVm

sql> select * from emp_old;51Testing软件测试网.zMl

Xq\?!AP

'@;I6OK?8f0　　2.parallel direct-load insert6P,J|C(N(P0

51Testing软件测试网2B*^7WD)dy

sql> alter session enable parallel dml;51Testing软件测试网U-P]Au

51Testing软件测试网o

d8q0a+WWyS

sql> insert /* parallel(emp,2) */ into emp nologging51Testing软件测试网i,kYM)f*WN0tf(Of

51Testing软件测试网P\9hqT:|U6o5d%O

sql> select * from emp_old;51Testing软件测试网SS4H^hyr

51Testing软件测试网fNC#U_ D,|z

3.using sql*loaderU\3f1Sa-~(s0

51Testing软件测试网)LE(p&^ E

xsS

sql> sqlldr scott/tiger \51Testing软件测试网uA9qki)mp'l

51Testing软件测试网)Ek&CYQ

sql> control = ulcase6.ctl \2@k;HR$D:H[n;S0

51Testing软件测试网

SP*L9vm(om/J

sql> log = ulcase6.log direct=true,Ay{*UM.l!F)]0