Maahjoor wrote:Patience, Grasshopper
i realy need your kind help.
Maahjoor wrote:"10g" is a marketing lable. What version of 10g - eg: 10.2.0.1.0 ?? we need all decimals
Dear all ,
i have two questions. please guide me thoroughly.
1. i want to change the scott schema NLS_LANG to LatinArabic AR8ISO8859P6 ISO
2. i want to set my sga size to 1gb.
i have oracle database 10g release 2 installed on windows 7 32 bit.
I need your kind help.
Maahjoor wrote:And what did you find when you googled "ora-12705"?
i just try to update the registry key under oracle home NLS_LANG to LatinArabic AR8ISO8859P6 , but the database give the following error
ora-12705: cannot access nls data files or invalid environment specified.
Maahjoor wrote:Sorry, but ALL NLS settings are really session settings. If they are set at the DB or OS, it is just to establish a default that can be inherited by the session. But in the end, it is the session that actually uses them.
thank you., but it is session level, ii need permanent changes to the schema.
[oracle@localhost ~]$ oerr ora 12705 12705, 00000, "Cannot access NLS data files or invalid environment specified" // *Cause: Either an attempt was made to issue an ALTER SESSION command // with an invalid NLS parameter or value; or the environment // variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was incorrectly // specified, therefore the NLS data files cannot be located. // *Action: Check the syntax of the ALTER SESSION command and the NLS // parameter, correct the syntax and retry the statement, or // specify the correct directory path/values in the environment // variables.