Re: sqlldr not recognizing a file without an extension on Solaris

From: Terry Dykstra <>
Date: Thu, 18 Feb 2010 20:06:26 GMT
Message-ID: <65hfn.66209$Db2.10929_at_edtnps83>

"z1hou1" <> wrote in message
> Hi,
> I am running a sqlldr command line on Solaris and the data file that I
> need to load WILL not have an extension. On DOS/Windows, that is not
> an issue since I can simply append a "." to the file name and sqlldr
> recognizes it. On Solaris/Unix, it expects a file with the explicit
> "." at the end of the file name.
> So if the data file name is accountInputFile (note no dot or
> extension), sqlldr responds by saying that the file name it expects is
> accountInputFile.dat if I do not specify anything other than
> data=accountInputFile.
> If I do specify data=accountInputFile. as in windows/dos for a similar
> situation, sqlldr attempts to find a file called "accountInputFile."
> with the explicit "." at the end of the file.!
> In short, on Solaris, there is, for me, no way of making sqlldr load a
> data file with no extension and no "." (dot).
> Can someone help me please?

put double quotes around the filename

Terry Dykstra 
Received on Thu Feb 18 2010 - 14:06:26 CST

Original text of this message