3

I have a data file that is in Windows format, and would like to load it in to Oracle with sqlldr. Unfortunately the Unix version doesn't intelligently detect with Windows format so I have a load of records with \r in them. Strangely, the Windows version would intelligently detect it.

Is there a parameter I can use in the control file to "switch on" auto detection? I don't want to assume the file will always be in Windows format?

Greg Reynolds
  • 9,736
  • 13
  • 49
  • 60

1 Answers1

2

Just a quick note on UNIX

unix has a utility - dos2unix (sometimes called dos2ux) that will change carriage control on files from Windows to UNIX. It is a one line command.

There is no option in sqlldr ctl files for carriage control other than DELIMITED BY. The 'DELIMITED BY' clause in the control file lets you specify a single character, not two. Windows text files have two characters.

Not what you wanted hear. I'm sure.

jim mcnamara
  • 16,005
  • 2
  • 34
  • 51