1748180 Members
4005 Online
108759 Solutions
New Discussion юеВ

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 4
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.