This discussion is archived
2 Replies Latest reply: May 3, 2013 5:30 AM by N K RSS

Override NLS_LANG in replicated environment

N K Pro
Currently Being Moderated
Hello,

I am working on Version 11.1.1.1.2_03 , 11.2.0.3.6 DB .

My DB is set to use the following:

NLS_LANG = "AMERICAN_AMERICA.WE8ISO8859P15"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8ISO8859P15"


However, clients connecting to the database have been setting this for themselves for so long that its impossible to fix some characters in this huge database now :

SPANISH_SPAIN.WE8ISO8859P15

My question is, is there any way I can override GG from taking the DB settings without setting an env variable as $NLS_LANG like below:

GGSCI (dbrep) 20> sh echo $NLS_LANG

SPANISH_SPAIN.WE8ISO8859P15

I took a look at the reference guide but couldn't come up with any parameter.

Greetings,
N K

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points