SQL*Loader - Running SQL*Loader (sqlldr)

Card Puncher Data Processing

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.

  • or in the batch file / console that start SQLLoader
sqlldr usere@tnsnames CONTROL=myControlFile.ctl   skip=1   

Discover More
Card Puncher Data Processing
Oracle - SQL*Loader

A utility data loader for the Oracle database Reason: NLS_NUMERIC_CHARACTERS is equal to ',.' or '.,' based upon the Territory (NLS_LANG) you are in. Example: The NLS_LANG...

Share this page:
Follow us:
Task Runner