Re: sql*loader infile file name

Jared Still
On Thu, Aug 5, 2010 at 10:41 AM, <Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx>wrote:

> Folks,
>
> I have a file on a unix box that was created on an IBM mainframe that I
> want to load into a table.  Let's call it mainframe_file.  When I try to
> use SQL*Loader, it says the following;
>
> SQL*Loader-500: Unable to open file (mainframe_file.dat)
> SQL*Loader-553: file not found
>
>
That's because sqlldr uses .dat as a default extension.

If the file name is static, just create a link in the same directory to
<filename>.dat
If it is not static, add the ln command to the script.

$>  ln -s mainframe_file mainframe_file.dat

Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Other related posts: