SQL*Loader-503: error appending extension to file name?

[wellster34]

Hi,

Does anyone know the reasoning/solution for the following SQL*Loader Error 503:


SQL*Loader-503: error appending extension to file name

Cause: SQL*Loader could not append the default extension to create the filename. The given name could be too long or contain illegal characters.

Action: Check the specified filename.

Please note that we just upgraded our Oracle Database in our test environment from 7.3.4 to 8.1.7. The before test was fine and now for the after testing, I'm getting this error? Does anyone know what it means or a possible solution?

Also, I got the following addition information which means nothing to me...

Additional information: 7217

Thanks

 

[Turkbear]

Hi,Please post your Control file and specify what command line parameters you used..

Thanks,

 

[wellster34]

Found out that on the 8.1.7 database I was attempting to run SQL*Loader with the old 7.3.4 environment variables.

It must have caused a conflict so that is why the error was raised.

I have run my SQL*Loader successfully using the 8.1.7 version!

Thanks for responding.