topic Re: SQLLOADER in Operating System - HP-UX

SQLLOADER

Prabhu_7 — Mon, 08 Mar 2004 15:08:05 GMT

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

Re: SQLLOADER

Michael Schulte zur Sur — Mon, 08 Mar 2004 15:36:40 GMT

Hi,

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

Michael

Re: SQLLOADER

Prabhu_7 — Mon, 08 Mar 2004 15:44:51 GMT

Yes.

I used wc -l

Re: SQLLOADER

Thierry Poels_1 — Mon, 08 Mar 2004 15:58:49 GMT

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.

Re: SQLLOADER

Prabhu_7 — Mon, 08 Mar 2004 16:11:18 GMT

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

Thanks a lot.