From: fbortel@nescape.net   
      
   M Mueller wrote:   
      
   > OS - Windows NT 4.0 Enterprise Edition   
   > DB Version - 8.1.7.4.1   
   >   
   > When trying to change the Character Set from US7ASCII to WE8MSWIN1252,   
   > we complete the following steps from SVRMGR, connected as internal:   
   >   
   > SHUTDOWN IMMEDIATE;   
   > STARTUP MOUNT EXCLUSIVE;   
   > ALTER SYSTEM ENABLE RESTRICTED SESSION;   
   > ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;   
   > ALTER SYSTEM SET AQ_TM_PROCESSES=0;   
   > ALTER DATABASE OPEN;   
   > ALTER DATABASE CHARACTER SET WE8MSWIN1252;   
   >   
   > Here we receive the following oracle error:   
   >   
   > ORA-01679: database must be mounted EXCLUSIVE and not open to activate   
   >   
   > The strange part is that this has worked on two other database   
   > servers.  One is the same Oracle version, but on Windows 2000 Advanced   
   > Server.  The other database is the same Oracle version and same   
   > operating system.   
   >   
   > Any thoughts?   
   >   
   > Thanks in advance,   
   > Melissa Mueller   
   > mmueller@lanvision.com   
      
   Are you sure? The last two commands seem reversed; you definitly open   
   your database before changing the characterset   
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)