ITPub博客

首页 > Linux操作系统 > Linux操作系统 > sqlldr的问题

sqlldr的问题

原创 Linux操作系统 作者:jolly10 时间:2008-07-17 14:03:58 0 删除 编辑
[oracle@qht108 sqlldr]$ cat para.txt
userid=l5m/l5m
control='/home/oracle/sqlldr/control.txt'
data='/home/oracle/sqlldr/data.txt'
log='/home/oracle/sqlldr/log.txt'
bad='/home/oracle/sqlldr/bad.txt'
rows=300


[oracle@qht108 sqlldr]$ sqlldr parfile=para.txt

SQL*Loader: Release 10.2.0.4.0 - Production on Thu Jul 17 13:48:52 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Commit point reached - logical record count 20
Commit point reached - logical record count 40
Commit point reached - logical record count 60
Commit point reached - logical record count 80
Commit point reached - logical record count 100
Commit point reached - logical record count 120
Commit point reached - logical record count 140
Commit point reached - logical record count 160
Commit point reached - logical record count 180
...

明明指定了rows=300,为何没有生效?

log.txt如下:
SQL*Loader: Release 10.2.0.4.0 - Production on Thu Jul 17 13:51:24 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Control File:   /home/oracle/sqlldr/control.txt
Data File:      /home/oracle/sqlldr/data.txt
  Bad File:     /home/oracle/sqlldr/bad.txt
  Discard File:  none specified

(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     300 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

Table LOAD_01, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
U_ID                                                      RECNUM
OWNER                               FIRST     *   ,       CHARACTER
TABLE_NAME                           NEXT     *   ,       CHARACTER
TABLESPACE_NAME                      NEXT     *   ,       CHARACTER
CLUSTER_NAME                         NEXT     *   ,       CHARACTER
IOT_NAME                             NEXT     *   ,       CHARACTER
STATUS                               NEXT     *   ,       CHARACTER
...
DEPENDENCIES                         NEXT     *   ,       CHARACTER
COMPRESSION                          NEXT     *   ,       CHARACTER
DROPPED                              NEXT     *   ,       CHARACTER

value used for ROWS parameter changed from 300 to 20
....

为何把300自动改成20了呢

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

请登录后发表评论 登录
全部评论

注册时间:2008-02-20

  • 博文量
    263
  • 访问量
    769050