Re: sql*loader infile file name
- From: Igor Neyman <igor.neyman@xxxxxxxxx>
- To: Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx
- Date: Thu, 5 Aug 2010 13:50:16 -0400
Did you try to end the filename with the "dot" (mainframe_file.), i.e.:
sqlldr userid=$DB_USER/$DB_PASSWORD "parfile=mainframe_file.par
control=mainframe_file.ctl data=mainframe_file."
Regards,
Igor Neyman
On Thu, Aug 5, 2010 at 1:41 PM, <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
>
>
> I have tried using quotes around the name and overrides at the command
> line, such as;
>
> sqlldr userid=$DB_USER/$DB_PASSWORD "parfile=mainframe_file.par
> control=mainframe_file.ctl data='mainframe_file'",
>
> to no avail. I have to rename mainframe_file to mainframe_file.dat for
> the process to work.
>
> What gives? I really do not like the idea of renaming or copying the
> file, I just want to be able to give it a name and have it suck the file
> up.
>
> thanks,
> Michael
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
