Home » RDBMS Server » Server Utilities » SQLLDR loading more records than in the file
SQLLDR loading more records than in the file [message #74161] Thu, 23 September 2004 12:02 Go to next message
Fuad H
Messages: 6
Registered: September 2004
Junior Member
I have a flat Seq file( on a VMS environment) which contains 654207 records.

1. When using sqlldr to load this file into the Oracle 9i table, the LOG file reported that it successfully loaded 654218 and rejected 33 records!  How is this possible since I only had 654207 records in the file which I confirmed.

FH

Report message to a moderator

Re: SQLLDR loading more records than in the file [message #74175 is a reply to message #74161] Tue, 28 September 2004 10:38 Go to previous message
Fuad H
Messages: 6
Registered: September 2004
Junior Member
Problem Resolved!

Turned out the file had a CR/LF in the middle of some records and so it considered the 2nd half of the record line as the next record.

FH

Report message to a moderator

Previous Topic: Import error while enabling constraints
Next Topic: Problem Loading Date/Time Field
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 09:56:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.