Sorry my last reply was maybe not that clear - 'NLS_LANG' is made up of the following 3 parameters from NLS_DATABASE_PARAMETERS
The first 2 are just normal spfile settings - the last one however is specified at database creation time and is more difficult to change..... Sometimes it can just be changed but other times it cannot.(have a look at csscan for more information)
Which characterset do you actually want to use? Are you storing non english characters?
It might be easier to set your os NLS_LANG to match the database?
please tel me what is the equivelent nls_lang for client
for following database nls_lang
in reality i am using
english characters only but few special characters may come.
! # $ & ' ( ) * + , / : ; = ? @ [ ] etc.......
please find the required version detail below.
Oracle Database 11g Express Edition Release 18.104.22.168.0 - Production
PL/SQL Release 22.214.171.124.0 - Production
"CORE 126.96.36.199.0 Production"
TNS for 32-bit Windows: Version 188.8.131.52.0 - Production (2008)
NLSRTL Version 184.108.40.206.0 - Production
So you are on windows - you can set it either just for a dos session by running
or you can add it as a system environment variable or you can add it in the registry.
Yes that isn't doing datapump - it's just generating a SQL file with create table / insert commands etc as plain text. That can still have an issue if the charactersets don't match you may get SQL generated that contains 'strange' characters. Sqldeveloper will also pick up the value of any environmnet variables/ registry settings in the same way any other client would.