This content has been marked as final. Show 1 reply
As I see you have MOS access I suggest to check:
[url https://support.oracle.com/epmos/faces/DocContentDisplay?id=257909.1]SQL*Loader And NLS ID 257909.1
See more info how to setup NLS_LANG for you env:
[url https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=179133.1 ]MOS: The correct NLS_LANG in a Windows Environment Doc ID: 179133.1
[url https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=264157.1]MOS: The correct NLS_LANG setting in Unix Environments Doc ID: 264157.1
And I would convert my input file to UTF8 encoded if your database has an UTF character set so you could leave UTF8 at NLS_LANG as well.
Edited by: Zoltan Kecskemethy on Jun 4, 2013 4:59 PM