Toad World® Forums

SQL*Loader issue...


#1

I am new to the loader in TOAD. I have a pretty big file I need to load that is a standard fixed length text file with a carriage return and line feed at the end of each line. I am trying to setup a repeatable load because there are so many fields.

The first basic option is whether this is a Stream file, Fixed, or Variable. I want to say fixed. But then there is record length. I am not sure if I enter the number of characters only or include the carriage return and line feed. My errors are somewhat random making me think it is parsing the line funny. I guess I could use Stream option but then I don’t know what goes into the “end of string” field.

Any suggestions would be appreciated!
Thanks,
Dave