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 [email protected] CONTROL=myControlFile.ctl   skip=1   

Powered by ComboStrap