| SQLLDR [message #395362] |
Wed, 01 April 2009 03:48  |
esaimozhi
Messages: 3
Registered: April 2009
|
Junior Member |
|
|
Hi,
I was trying to load the .csv file using sqlldr. The log file show the message "commit point reached - logical record count 1". but My .CSV file as around 167 records.
it's not generated .bad file also.
FYI :
i have used same .ctrl file to load other data (CSV) files. it worked.
I think, problem in reading .csv file - End Of Line read and not able to read the next record.
Please help me to fix the issue.
Is it require any environment_variable setup?
Thanks in advance !
Esai
|
|
|
|
|
|
| Re: SQLLDR [message #395365 is a reply to message #395363] |
Wed, 01 April 2009 03:57  |
esaimozhi
Messages: 3
Registered: April 2009
|
Junior Member |
|
|
Here is the Log Detail:
SQL*Loader: Release 10.2.0.1.0 - Production on Wed Apr 1 02:18:01 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: DEFINEDFIELDS.ctl
Data File: DEFINEDFIELDS.CSV
Bad File: DEFINEDFIELDS.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table DEFINEDFIELDS, 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
------------------------------ ---------- ----- ---- ---- ---------------------
CERTIFICATENUMBER FIRST * , O(") CHARACTER
BRANCHNUMBER NEXT * , O(") CHARACTER
PLANCODE NEXT * , O(") CHARACTER
PRIMARYLASTNAME NEXT * , O(") CHARACTER
PRIMARYFIRSTNAME NEXT * , O(") CHARACTER
PRIMARYINITIAL NEXT * , O(") CHARACTER
PRIMARYDATEOFBIRTH NEXT * WHT O(") CHARACTER
AAA NEXT * , O(") CHARACTER
(FILLER FIELD)
PRIMARYGENDER NEXT * , O(") CHARACTER
SECLASTNAME NEXT * , O(") CHARACTER
SECFIRSTNAME NEXT * , O(") CHARACTER
SECINITIAL NEXT * , O(") CHARACTER
SECONDARYDATEOFBIRTH NEXT * WHT O(") CHARACTER
BBB NEXT * , O(") CHARACTER
(FILLER FIELD)
SECONDARYGENDER NEXT * , O(") CHARACTER
ADDRESSLN1 NEXT * , O(") CHARACTER
ADDRESSLN2 NEXT * , O(") CHARACTER
ADDRESSLN3 NEXT * , O(") CHARACTER
(FILLER FIELD)
PROV NEXT * , O(") CHARACTER
POSTAL NEXT * , O(") CHARACTER
BANKID NEXT * , O(") CHARACTER
LOCLIMIT NEXT * , O(") CHARACTER
(FILLER FIELD)
LNACCT NEXT * , O(") CHARACTER
INST NEXT * , O(") CHARACTER
TRANSIT NEXT * , O(") CHARACTER
DEBITACCT NEXT * , O(") CHARACTER
EFFECTIVEDATE NEXT * WHT O(") CHARACTER
value used for ROWS parameter changed from 64 to 43
Table DEFINEDFIELDS:
1 Row 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.
Space allocated for bind array: 255162 bytes(43 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 1
Total logical records rejected: 0
Total logical records discarded: 0
Run began on Wed Apr 01 02:18:01 2009
Run ended on Wed Apr 01 02:18:01 2009
Elapsed time was: 00:00:00.24
CPU time was: 00:00:00.08
Thanks,
Esai
|
|
|
|
| Re: SQLLDR [message #395371 is a reply to message #395363] |
Wed, 01 April 2009 04:26 |
esaimozhi
Messages: 3
Registered: April 2009
|
Junior Member |
|
|
Hi ,
Atlast , i have loaded the file by changing the data file Format as - Converted to ANSI and Preference as - Multi-Line. It loaded the data.
Still i am not sure about the problem..
Regards,
Esai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
