Re: sql*loader infile file name
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx
- Date: Thu, 5 Aug 2010 12:08:21 -0700
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:
