三思在《涂抹ORACLE》第78页、80页都讲到了Linux/UNIX下换行符为"\n",而我测试的结果是比较有意思的：AIX下换行符为“\n”,而WINDOWS环境下的linux虚拟机上换行符为“\r\n”.

环境：
PC操作系统：windows xp sp2
vmware server版本：1.0.3
RHEL:4.5

windows下Red Hat Enterprisse linux4-U5（32位）虚拟机下：

[oracle@10g_n1 5]$ uname -a
Linux 10g_n1 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux

[oracle@10g_n1 5]$ more ldr_case11_4_t.ctl
LOAD DATA
INFILE ldr_case11_4.dat "str '|\n'"
DISCARDFILE ldr_case11_4_t.dsc
TRUNCATE INTO TABLE MANAGER
FIELDS TERMINATED BY ','
(MGRNO, MNAME, JOB, REMARK)
[oracle@10g_n1 5]$
[oracle@10g_n1 5]$
[oracle@10g_n1 5]$ sqlldr scott/tiger ldr_case11_4.ctl

SQL*Loader: Release 10.2.0.1.0 - Production on Tue Jan 5 16:40:46 2010

Commit point reached - logical record count 3
[oracle@10g_n1 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@10g_n1 5]$
[oracle@10g_n1 5]$
[oracle@10g_n1 5]$ sqlldr scott/tiger ldr_case11_4_t.ctl

SQL*Loader: Release 10.2.0.1.0 - Production on Tue Jan 5 16:40:34 2010

Commit point reached - logical record count 1
[oracle@10g_n1 5]$
[oracle@10g_n1 5]$
[oracle@10g_n1 5]$
[oracle@10g_n1 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@10g_n1 5]$
[oracle@10g_n1 5]$

AIX 5.3的测试过程：

[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

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

Commit point reached - logical record count 1
[oracle@n01 5]$

ITPub博客

windows下linux虚拟机oracle处理换行符的奇怪之处

最新文章