Changes are made to the content of some of the language and territory definition files in Oracle Database 10g and later releases.
- Run the
cr9idata.plscript, which by default is in the following location:
If the installation type you chose does not include this directory, you can find the
cr9idata.plscript in the same directory path in a default Oracle Database Client installation.
- Set the
ORA_NLS10environment variable to point to the directory
ORACLE_HOME\nls\data\9idata, into which
cr9idata.plcopies the new language and territory definition files.
ORA_NLS10must have this value each time the affected client programs are started. Therefore, set the variable permanently in a startup script or, on the Microsoft Windows platform, set it in the Windows Registry.