SQL*Loader - Running SQL*Loader (sqlldr)

Localization (Before Running SQLLOADER)

SqlLoader is an utility tool and can not change the environment parameters, especially the NLS Localization parameter. From Checklist before starting SQL*Loader

You have to change them:

• in the database.

Ex: Set NLS_LANG to the desired territory and character set to prevent wrong data to be loaded or getting errors due to this data.

NLS_LANG=<Language_Territory.Characterset>
NLS_LANG="Dutch_The_Netherlands.WE8ISO8859P15"

• or in the batch file / console that start SQLLoader

set NLS_LANG=DUTCH
sqlldr usere@tnsnames CONTROL=myControlFile.ctl   skip=1