sqlldr支持多字符分隔符文件导入。
首先看我的数据文件和控制文件:
[oracle@jumper tmp]$ cat data.ctl
load data
into table
TEST
fields terminated by "|+|"
(
T_ID,
T_VOL
)
[oracle@jumper
tmp]$ cat data.txt
20021228000000|+|00120000
20021228000000|+|00130000
20021228000000|+|00140000
20021||8000000|+|00140000
20021++8000000|+|00140000
创建测试表:
[oracle@jumper tmp]$ sqlplus eygle/eygle
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Nov 21 13:21:16 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 -
Production
With the Partitioning option
JServer Release 9.2.0.4.0 -
Production
SQL> create table test
2 (T_ID varchar2(20),
3 T_VOL
varchar2(20)
4 );
Table created.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release
9.2.0.4.0 - Production
With the Partitioning option
JServer Release
9.2.0.4.0 - Production
加载数据:
[oracle@jumper tmp]$ sqlldr eygle/eygle control=data.ctl
data=data.txt
SQL*Loader: Release 9.2.0.4.0 - Production on Tue Nov 21 13:23:53 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Commit point reached - logical record count 5
[oracle@jumper tmp]$ sqlplus
eygle/eygle
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Nov 21 13:23:57 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 -
Production
With the Partitioning option
JServer Release 9.2.0.4.0 -
Production
SQL> select * from test;
T_ID T_VOL
-------------------- --------------------
20021228000000
00120000
20021228000000 00130000
20021228000000 00140000
20021||8000000
00140000
20021++8000000 00140000
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release
9.2.0.4.0 - Production
With the Partitioning option
JServer Release
9.2.0.4.0 - Production
只作了简单验证，不知道复杂情况会不会有问题。
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024