sqlldr的問題
[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了呢
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- sqlldr載入效能問題的排查SQL
- sqlldr經常報錯的問題SQL
- 使用sqlldr匯入日期格式欄位的問題SQL
- [20160910]sqlldr使用問題.txtSQL
- 生產環境sqlldr載入效能問題及分析之一SQL
- 生產環境sqlldr載入效能問題及分析之二SQL
- sqlldr的使用SQL
- sqlldr的例子SQL
- 利用sqlldr工具進行資料遷移時發現的問題解決方法SQL
- sqlldr標準輸出未處理導致批處理掛起問題SQL
- [20140109]sqlldr使用direct=true載入資料的問題.txtSQL
- sqlldr的用法小結SQL
- sqlldr的用法總結SQL
- SQLLDR 命令SQL
- SQLLDR 教程SQL
- sqlldr使用SQL
- Sqlldr操作SQL
- 幾個SQLLDR的典型案例SQL
- SQLLDR的一個筆記SQL筆記
- sqlldr詳解SQL
- sqlldr用法全SQL
- sqlldr配合shell解決sqlldr 控制檔案中引入變數的方案SQL變數
- sqlldr的學習與總結SQL
- sqlldr和external table的關係!SQL
- SQLLDR-樣例SQL
- 測試oracle sqlldrOracleSQL
- oracle sqlldr匯入OracleSQL
- sqlldr詳解2SQL
- sqlldr增加判斷。SQL
- oracle sqlldr 總結OracleSQL
- Sqlldr效能引數SQL
- sqlldr與external tableSQL
- ORACLE 的載入工具SQLLDR應用OracleSQL
- sqlldr中使用條件裝載及作為外部表訪問SQL
- SQLLDR-CTL檔案SQL
- 資料匯入SQLLDRSQL
- Oracle SQL Loader(sqlldr)OracleSQL
- 【sqlldr載入資料】SQL