使用sqlldr的简单例子-转贴

创建测试表：ITPUB个人空间E)t&x"_5N&AU$q5E'm
create table DEMO
T5J0R ox&E0(
6_K|3OC0 DEPTNO NUMBER(2) not null,
bl],p`M0 DNAME VARCHAR2(14),ITPUB个人空间T0b'v1a)U [+d!R|){
LOC VARCHAR2(13)ITPUB个人空间K1\%Q}*Qc?
);
6fB:mN:u"k0

例子1：装载定界数据类型为csv(Comma-Separated Value)

C:sqlldr userid=scott/tiger control=load.ctl data=data.csv direct=y

load.ctl内容如下：

LOAD DATA ITPUB个人空间li^uD
INFILE * ITPUB个人空间{Q9W)MRODng'N!S
INTO TABLE DEMO ITPUB个人空间e*R0f:w9U/h(h&mKL x
TRUNCATE ITPUB个人空间/F8uW,J+x$C`9XV
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
2kD`O6Vy Fh0(DEPTNO,ITPUB个人空间$H f5i{"pk7g
DNAME,ITPUB个人空间3Z|Jk3m
W1M
LOC
)tv^.Vy"s!\8Lf
i&Mf0)

数据文件data.csv的内容如下：

"10","ACCOUNTING","NEW YORK"
?7JZ0u*|q~.I0"20","RESEARCH","DALLAS"ITPUB个人空间!JXQ#S
z4S
"30","SALES","""CHICAGO"""ITPUB个人空间Hn/p*s#DV
"40","OPERATIONS","BOSTON"ITPUB个人空间:T'?X,[;Nt,Y8\2|Z
"50","","Virginia"ITPUB个人空间O}B r'o/Vc#x8M#v f
"60",,"Virginia"

例子2：装载定界数据类型为tsv(制表符分隔)

C:sqlldr userid=scott/tiger control=load.ctl data=data.tsv direct=y

load.ctl内容如下：

LOAD DATA
#v z
`e!_2mL,@0INFILE * ITPUB个人空间-z%?B/vU8O C
INTO TABLE DEMO ITPUB个人空间F;V&v l+hX T/? i8y
TRUNCATE
+x8{
N(_+uYRF0FIELDS TERMINATED BY X'09'ITPUB个人空间gQ%rPj~1p%@-U[c
(DEPTNO,ITPUB个人空间?7m6F.S+Rx!@
DNAME,ITPUB个人空间n\4WLZ'U
LOC

Szm5zYj1Z&E0)

数据文件data.tsv的内容如下：

10 ACCOUNTING NEW YORK
.f5x)E%S+k9gPyV7e020 RESEARCH DALLASITPUB个人空间$Pe^%U~ yX
30 SALES "CHICAGO"ITPUB个人空间$g_ZzE?8s:A9[
40 OPERATIONS BOSTON
x!Cz4A$~3bG S050 Virginia
*P+CW/W EG-c060 Virginia

注意：连续两个制表符表示中间的列为空