SQL*Loader: Release 9.2.0.7.0 - Production on Wed Nov 14 09:02:04 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Control File: /users/dwhradm/SCRIPTS/PASSERELLES/KPIDRE/CTL/TFX_ZONE_CELL.ctl
Data File: /users/dwhradm/LOGS/PASSERELLES/KPIDRE/ZONE.27-10-07.csv
Bad File: /users/dwhradm/LOGS/PASSERELLES/KPIDRE/TFX_ZONE_CELL.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 10000
Continuation: none specified
Path used: Direct
Silent options: FEEDBACK
Table TFX_ZONE_CELL, loaded from every logical record.
Insert option in effect for this table: TRUNCATE
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ZONE_NAME FIRST * ; CHARACTER
CELL_ID NEXT * ; CHARACTER
Table TFX_ZONE_CELL:
788170 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 788170
Total logical records rejected: 0
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 171
Total stream buffers loaded by SQL*Loader load thread: 2
Run began on Wed Nov 14 09:02:04 2007
Run ended on Wed Nov 14 09:02:12 2007
Elapsed time was: 00:00:07.96
CPU time was: 00:00:04.84
Partager