 SQL Loader ---One record is missed [message #136074] |
Mon, 05 September 2005 23:54  |
purveshvora
Messages: 6
Registered: August 2005
Location: Mumbai
|
Junior Member |
|
|
Hi,
I have a text file which is having blank lines in the end. I delete the blank lines in the shell script.
When I call the sql loader it is not loading the last record.
THe file looks like this
1. 11
2. 12
3. 13
4. 14
I guess that this is because there is no last line and \n is required.
So it should work if the data is like foll.
1. 11
2. 12
3. 13
4. 14
5.
so I tried
$echo "\n" >> file
$echo "" >> file
$echo >> file
but it appends two lines or spaces and it gives bad record for the second last line.
Can anybody please guide me on this?
Thanks,
Purvesh
[Updated on: Mon, 05 September 2005 23:56] Report message to a moderator |
|
|
|
| Re: SQL Loader ---One record is missed [message #136174 is a reply to message #136074] |
Tue, 06 September 2005 08:42  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Please reframe the question.
Your last line is a 'blank' which is actually space.
1. 11
2. 12
3. 13
4. 14
5.
Are you always looking to skip the last line/ record ( which is blank)?
If so please look into this thread
http://www.orafaq.com/forum/t/49428/0/
If nothing is helping, post again.~
Thanks & Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
