Home » RDBMS Server » Server Utilities » SQL Loader and end of record
SQL Loader and end of record [message #73730] Fri, 25 June 2004 08:58 Go to next message
Jim Newhall
Messages: 1
Registered: June 2004
Junior Member
Greetings,

 I have a pipe delimeted text file to load, but each record is not ended with a carriege return line feed.  How do I change what sqlloader to expect for an end of record from the text file?

My end of record is "Lә&#124N"  without the quotes.

Thank you

Report message to a moderator

Re: SQL Loader and end of record [message #73731 is a reply to message #73730] Fri, 25 June 2004 09:24 Go to previous message
jim
Messages: 74
Registered: July 2000
Member
I think I found the answer.

I need to add "str X'hex string here for eor'"
to load data infile.

Report message to a moderator

Previous Topic: exp/imp complie=y,compress=y doughts
Next Topic: problem with fused accounts!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

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