[20140426]使用sqlldr导入.txt
http://www.bobbydurrettdba.com/2014/04/21/sqlloader-express-bug/,自己重复测试看看.
SCOTT@test01p> @ver
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0
create table test
(a varchar2(20),
b varchar2(20),
c varchar2(20),
d varchar2(20));
D:\tmp>cat test.dat
cat test.dat
a,b,c,d
f,g,h,i
j,k,l,m
D:\tmp>sqlldr scott/btbtms@test01p table=test
sqlldr scott/btbtms@test01p table=test
SQL*Loader: Release 12.1.0.1.0 - Production on Sat Apr 26 20:00:20 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Express Mode Load, Table: TEST
Path used: External Table, DEGREE_OF_PARALLELISM=AUTO
Table TEST:
3 Rows successfully loaded.
Check the log files:
test.log
test_%p.log_xt
for more information about the load.
SCOTT@test01p> select * from test;
A B C D
------- ------- ------ ------
a b c d
f g h i
j k l m
--并没有看到它的问题,我猜测.他的机器设置了
SCOTT@test01p> column c noprint
SCOTT@test01p> select * from test;
A B D
-------------------- -------------------- --------------------
a b d
f g i
j k m
--而并不是什么bug.
--不过这种简单的导入方式,我倒是值得我学习的.