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