Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
cancel
Showing results for 
Search instead for 
Did you mean: 

SQLLOADER

SOLVED
Go to solution
Prabhu_7
Frequent Advisor

SQLLOADER

Hi,

I have a data file which contains 4500 records in it.
When i download it to oracle , it downloads
4501 records...and i'm trying to figure out from where that one extra record is getting loaded.i dont see any blanks / null records in oracle table..

Any thoughts ?

Thanks
4 REPLIES
Michael Schulte zur Sur
Honored Contributor

Re: SQLLOADER

Hi,

how did you find out 4500 records?
Did you use wc -l?

Michael
Prabhu_7
Frequent Advisor

Re: SQLLOADER

Yes.

I used wc -l
Thierry Poels_1
Honored Contributor
Solution

Re: SQLLOADER

hi,

just a wild guess: maybe the last line is not counted by "wc" due to missing CR ??

try a "tail filename" & "tail filename | wc" and check the result.

good luck,
Thierry.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.
Prabhu_7
Frequent Advisor

Re: SQLLOADER

Yes you are right. Last records doesnt have a CR , so wc doesnt include in the count.

Thanks a lot.