OPTIONS (SKIP = 1 , bindsize = 2000000)
load data
infile 'd:/sqlload/new/test/test1.txt'
TRUNCATE
INTO TABLE myTab1
fields terminated by X'09'
TRAILING NULLCOLS
(
f1,
f2 DATE 'yyyy-mm-dd hh24:mi:ss',
f3 DATE 'yyyy-mm-dd hh24:mi:ss',
f4,
f5
)
SQL*Loader: Release 10.2.0.1.0 - Production on Thu Mar 10 00:36:30 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: D:\sqlload\new\test\loader2.ctl
Data File: d:/sqlload/new/test/changes2.txt
Bad File: D:\sqlload\new\test\changes2.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 1
Errors allowed: 50
Bind array: 64 rows, maximum of 2000000 bytes
Continuation: none specified
Path used: Conventional
Table myTAB1, 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
------------------------------ ---------- ----- ---- ---- ---------------------
CHANGE_KEY FIRST * WHT CHARACTER
CREATED_ON NEXT * WHT DATE yyyy-mm-dd hh24:mi:ss
LAST_UPDATED_ON NEXT * WHT DATE yyyy-mm-dd hh24:mi:ss
SORT_KEY NEXT * WHT CHARACTER
OWNER_ACCOUNT_ID NEXT * WHT CHARACTER
DEST_PROJECT_NAME NEXT * WHT CHARACTER
DEST_NAME NEXT * WHT CHARACTER
OPEN NEXT * WHT CHARACTER
STATUS NEXT * WHT CHARACTER
NBR_PATCH_SETS NEXT * WHT CHARACTER
CURRENT_PATCH_SET_ID NEXT * WHT CHARACTER
SUBJECT NEXT * WHT CHARACTER
ROW_VERSION NEXT * WHT CHARACTER
CHANGE_ID NEXT * WHT CHARACTER
TOPIC NEXT * WHT CHARACTER
Record 14424: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 14856: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 14912: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 15956: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 18237: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 19143: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 26699: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 27609: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 29223: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 29224: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 29274: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 32120: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 32346: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 32667: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 32884: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 34081: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 35143: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 35209: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 37902: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 38546: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 38866: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 40836: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 44345: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 44346: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 45865: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 46470: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 47405: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 47406: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 47742: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 49117: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 50241: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 50242: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 52678: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 52697: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 53143: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 55021: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 55022: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 55024: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 55072: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 55077: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 55092: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 55097: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 55765: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 56550: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 56552: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 57114: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 57999: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 58228: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 58717: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 58721: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
Record 60092: Rejected - Error on table myTAB1, column SUBJECT.
Field in data file exceeds maximum length
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table myTAB1:
60041 Rows successfully loaded.
51 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.
Space allocated for bind array: 247680 bytes(64 rows)
Read buffer bytes: 2000000
Total logical records skipped: 1
Total logical records read: 60092
Total logical records rejected: 51
Total logical records discarded: 0
Run began on Thu Mar 10 00:36:30 2011
Run ended on Thu Mar 10 00:38:07 2011
Elapsed time was: 00:01:36.44
CPU time was: 00:00:04.49
IKOXYZ \tNeed an Album art icon for each video item
OPTIONS (SKIP = 1 , bindsize = 2000000)
load data
infile 'd:/sqlload/new/test/test1.txt'
TRUNCATE
INTO TABLE myTab1
FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '^'
TRAILING NULLCOLS
(
f1,
f2 DATE 'yyyy-mm-dd hh24:mi:ss',
f3 DATE 'yyyy-mm-dd hh24:mi:ss',
subject,
f5
)