on 07-13-2011 5:37 AM
Dear all experts,
i encountered problem when i tried to change national character set and database character set according to note 102402 and 66902 both get this error:
ORA-12714: invalid national character set specified
when altering the database to UTF8(in note 66902) and to WE8DEC(in note 102402).
Any advice on this matter?
thank you in advance.
My hunch is right. apparently there is only 4 entries in V$NLS_VALID_VALUES. so how to populate correct content if it is even possible?
content:
LANGUAGE AMERICAN
TERRITORY AMERICA
CHARACTERSET US7ASCII
SORT BINARY
Any advise on this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
also i got really weird feeling like UTF8 and other character sets not exist, is there a way to confirm what is valid character set(ORA-12714: invalid national character set specified)? or what character set exists(the schema or table)? since it is strange for both command not work with the same error:
1. alter database character set WE8DEC;
2. ALTER DATABASE NATIONAL CHARACTER SET UTF8;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here I suggest to plan your Oracle upgrade immediately.
On your initial question - Search SDN/Google with ORA error code
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.