Oracle Database - ORA_NLS

> Database > Oracle Database

Table of Contents

1 - About

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.2 ORA_NLS
7.3 ORA_NLS32
8.x, 9.x ORA_NLS33
10g ORA_NLS10
Advertising
db/oracle/ora_nls.txt · Last modified: 2017/09/06 19:28 by gerardnico