Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> changing character sets - twice??

changing character sets - twice??

From: Joel Green <joel_at_volcanomail.com>
Date: 20 Nov 2001 09:00:11 -0800
Message-ID: <ae0dc928.0111200900.18ac59e@posting.google.com>


Hello,

Changing a character set on an 8.0.6 Oracle DB worked, but now it won't change to anything else!

The character and national character sets were set to US7ASCII. They were then changed to WE8DEC.

I did:

SVRMGR> connect sys as sysdba;
SVRMGR> shutdown immediate
SVRMGR> startup mount
SVRMGR> alter system enable restricted session;
SVRMGR> alter system set job_queue_processes = 0;
SVRMGR> alter database open;
SVRMGR> alter database character set WE8DEC;
SVRMGR> alter system disable restricted session; 
Also changed the national character set.

This worked fine.

However, when I do the same, but change back to US7ASCII, or UTF-8 (or anything else), it says:

    SVRMGR> alter database character set US7ASCII;     alter database character set US7ASCII

                                         *
    ORA-24329: invalid character set identifier

Both UTF-8 and US7ASCII show up with the query:

   SELECT parameter,value

     FROM v$nls_valid_values
     WHERE parameter = 'CHARACTERSET'

   ORDER BY value;

Which is baffling me :-)

Joel Received on Tue Nov 20 2001 - 11:00:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US