sqlldr not recognizing a file without an extension on Solaris

From: z1hou1 <z1hou1_at_gmail.com>
Date: Thu, 18 Feb 2010 11:55:35 -0800 (PST)
Message-ID: <48509797-3442-4797-ae0b-5c622d72d11a_at_c10g2000vbr.googlegroups.com>

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? Received on Thu Feb 18 2010 - 13:55:35 CST