| Cannot access NLS data files or invalid environment specified [message #456144] |
Sat, 15 May 2010 02:58  |
sandy_tp
Messages: 9
Registered: May 2010
Location: india
|
Junior Member |
|
|
Hi,
I exported oracle database from one server in a dmp file. then i imported it in another oracle database server. when i saw the imported data the columns which were storing german data is in rubbish characters.
then i remember that the database from where i exported is having nls language as german. i executed this statement to set the nls on the new server
alter system set nls_lang=german SCOPE=SPFILE
but now my database is not getting started always giving me error -
cannot access NLS data files or invalid environment specified.
i also set the path NLS_LANG=german in the solaris environment.
Regards
Sandy
|
|
|
|
| Re: Cannot access NLS data files or invalid environment specified [message #456147 is a reply to message #456144] |
Sat, 15 May 2010 03:22  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
It depends on:
1/ You source database character set
2/ Your export character set (see NLS_LANG at this time)
3/ Your import character set (see NLS_LANG at this time, "german" is NOT a character set but a language, so character set is default one: US7ASCII)
4/ your target database character set
To get it correct: export with source database character set, import with target database character set.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
