Re: NLS probleam

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Wed, 15 Nov 2000 11:06:50 -0000
Message-ID: <8utqsk$u2u$1@kermit.esat.net>

You must set the character set when the instance is first created. You cannot change it subsequently.

Dudi Naim wrote in message <3a103451_at_news.bezeqint.net>...
>Hi
>
>I need to change the NATIONAL CHARACTER SET from US7ASCII
>to WE8ISO8859P1
>
>but when i do
>
>SQL> SHUTDOWN IMMEDIATE;
>SQL> STARTUP MOUNT;
>SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
>SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
>SQL> ALTER DATABASE OPEN;
>SQL> ALTER DATABASE NATIONAL CHARACTER SET WE8ISO8859P1;
>
>I recived
>
>ORA-01679: database must be mounted EXCLUSIVE and not open to activate
>
>Please Help !!
>
>yoramn_at_cti2.com
>
>
>
Received on Wed Nov 15 2000 - 05:06:50 CST