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

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

"z1hou1" <z1hou1_at_gmail.com> wrote in message news: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?

put double quotes around the filename

-- 
Terry Dykstra 

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