该篇博客展示了如何使用Oracle的SQL*Loader工具从文本文件加载数据到数据库表中。通过示例脚本`ldr11_4.ctl`和`ldr_case11_4.dat`，解释了数据加载过程，包括数据截断、字段分隔以及记录计数。在两次数据加载操作中，一次成功加载3条记录，另一次仅加载1条记录，可能涉及换行符格式差异问题。
[oracle@n01 5]$ oslevel -r
5300-06
[oracle@n01 5]$
[oracle@n01 5]$
[oracle@n01 5]$ more ldr11_4.ctl
LOAD DATA
INFILE ldr_case11_4.dat "str '|\n'"
TRUNCATE INTO TABLE MANAGER
FIELDS TERMINATED BY ','
(MGRNO, MNAME, JOB, REMARK)
[oracle@n01 5]$
[oracle@n01 5]$
[oracle@n01 5]$ more ldr_case11_4.dat
10,SMITH,SALES MANAGER,This is SMITH.
He is a Sales Manager.|
11,ALLEN.W,TECH MANAGER,This is ALLEN.W.
He is a Tech Manager.|
16,BLAKE,HR MANAGER,This is BLAKE.
He is a Hr Manager.|
[oracle@n01 5]$
[oracle@n01 5]$
[oracle@n01 5]$ sqlldr scott/tiger ldr11_4.ctl
SQL*Loader: Release 10.2.0.1.0 - Production on Tue Jan 5 17:24:35 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Commit point reached - logical record count 3
[oracle@n01 5]$
[oracle@n01 5]$
[oracle@n01 5]$ more ldr_case11_4.ctl
LOAD DATA
INFILE ldr_case11_4.dat "str '|\r\n'"
TRUNCATE INTO TABLE MANAGER
FIELDS TERMINATED BY ','
(MGRNO, MNAME, JOB, REMARK)
[oracle@n01 5]$
[oracle@n01 5]$
[oracle@n01 5]$ sqlldr scott/tiger ldr_case11_4.ctl
SQL*Loader: Release 10.2.0.1.0 - Production on Tue Jan 5 17:25:09 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Commit point reached - logical record count 1
[oracle@n01 5]$
扫一扫
298
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
