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 -> NLS probleam

NLS probleam

From: Dudi Naim <yoramn_at_cti2.com>
Date: Mon, 13 Nov 2000 20:36:59 +0200
Message-ID: <3a103451@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 Mon Nov 13 2000 - 12:36:59 CST

Original text of this message

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