| changing nls_lang parameters to remove exporting questionable statistiocs errors [message #72939] |
Thu, 18 December 2003 21:35  |
Natraj
Messages: 53
Registered: March 2003
|
Member |
|
|
i hada doubt in changing Nls_lang parameter, i want to change it to we8mswin32 or anything elwse, i want to remove that exporting questionable statistics, at the same time i want the statistics, so i dont wanna set the statistics=none, my database details are as follows
SQL> select * from nls_session_parameters;
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY
$
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS
.,
NLS_CALENDAR
GREGORIAN
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_DATE_FORMAT
DD-MON-RR
NLS_DATE_LANGUAGE
AMERICAN
NLS_SORT
BINARY
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_TIME_FORMAT
HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY
$
NLS_COMP
BINARY
PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LENGTH_SEMANTICS
BYTE
NLS_NCHAR_CONV_EXCP
FALSE
17 rows selected.
I am also attaching the log file i got when i took the export , pls have alook at it, it says a s follows
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
.
NSQL> alter database cbprod character set al16utf16;
alter database cbprod character set al16utf16
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
SQL> alter database cbprod character set AMERICAN_AMERICA.WE8MSWIN1252
2 ;
alter database cbprod character set AMERICAN_AMERICA.WE8MSWIN1252
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> alter database cbprod character set us7ascii;
alter database cbprod character set us7ascii
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
SQL> alter database cbprod character set th8tisascii;
alter database cbprod character set th8tisascii
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
I get the following error. kindly advise me what to do, i need the solution today itself..
|
|
|
|
|
|
| Re: changing nls_lang parameters to remove exporting questionable statistiocs errors [message #72942 is a reply to message #72939] |
Fri, 19 December 2003 09:19  |
Roy
Messages: 30
Registered: May 2002
|
Member |
|
|
for example:
setenv NLS_LANG american_america.WE8MSWIN1252
To avoid questionable statistics error make sure the language settings of your database matches the NLS_LANG. You can see what language your database is using when you try an export. It will have a line saying 'Server uses ........ character set'.
So replace 'WE8MSWIN1252' part with the above server character set.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
