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

       三思在《涂抹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 Copyright (c) 1982, 2005, Oracle.  All rights reserved. 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 Copyright (c) 1982, 2005, Oracle.  All rights reserved. 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 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]$

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23137730/viewspace-624455/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23137730/viewspace-624455/