[20140426]使用sqlldr导入.txt

[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.
--不过这种简单的导入方式,我倒是值得我学习的.

上一篇:神奇的 routing mesh - 每天5分钟玩转 Docker 容器技术(100)


下一篇:[20160321]bvi使用问题2.txt