Re: SQLLDR won't accept files without .dat entension

lazytodd_at_hotmail.com (Todd Woods) wrote:

>I'm trying to load files into the system.. only problem.. the files
>don't have a .dat extension..... it keeps appending the filename to
>filename.dat, and filename.dat isn't there...
>
>anyway to keep it from looking for a .dat extension, or any way to
>force it to use the filename without the extension????
>
>oracle 8 on unix or NT...
>
>thanks
>Todd

In my experience,Sqlloader does not care what the file name is, if you specify it using the INFILE option within the .CTL file.. Received on Tue Nov 09 2004 - 15:34:46 CST