Oracle Database - ORA_NLS


ORA_NLS is an environment variable.

If your system is using multiple versions of Oracle, you must ensure that:

  • The appropriate ORA_NLS variable is set.
  • The corresponding NLS data files for the versions you are using are available.

The location-specific data is stored in a directory specified 4 by the ORA_NLS environment variable. For each new version of Oracle, there is a different ORA_NLS data directory. Oracle ORA_NLS variable that specifies the location of locale-specific data by version.

Oracle version Environment variable
7.3 ORA_NLS32
8.x, 9.x ORA_NLS33
10g ORA_NLS10

Powered by ComboStrap