Message-Id: <10711.124690@fatcity.com> From: GKor@rdw.nl Date: Fri, 15 Dec 2000 14:02:11 +0100 Subject: RE: Character sets in ORACLE 7 you can do the following : DON"T MAKE AN ERROR !!! update props$ set NLS_CHARACTERSET =3D 'WE8ISO8859P1'=20 in ORACLE8 you can read the note on metalink Note:66320.1 1. Make sure the parallel_server parameter in INIT.ORA is set to false = or it is not set at all. 2. Execute the following commands in Server Manager (svrmgrl): SVRMGR> SHUTDOWN IMMEDIATE; -- or NORMAL=20 SVRMGR> STARTUP MOUNT;=20 SVRMGR> ALTER SYSTEM ENABLE RESTRICTED SESSION;=20 SVRMGR> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=3D0;=20 SVRMGR> ALTER SYSTEM SET AQ_TM_PROCESSES=3D0; SVRMGR> ALTER DATABASE OPEN;=20 SVRMGR> ALTER DATABASE CHARACTER SET ;=20 SVRMGR> SHUTDOWN IMMEDIATE; -- OR NORMAL=20 SVRMGR> STARTUP RESTRICT;=20 3. Restore the parallel_server parameter in INIT.ORA, if necessary. 4. Execute the following commands in Server Manager: SVRMGR> SHUTDOWN IMMEDIATE; -- OR NORMAL SVRMGR> STARTUP; The double restart is necessary because of a SGA initialization bug, fixed in Oracle9i. To change the national character set replace the ALTER DATABASE CHARACTERSET command with ALTER DATABASE NATIONAL CHARACTER SET. You = can issue bothcommands together if you wish.The ALTER DATABASE [NATIONAL] CHARACTER SET command will return: ORA-01679: database must be mounted EXCLUSIVE and not open to activate - if you do not enable restricted = session - if you startup the instance in PARALLEL/SHARED mode - if you do not = set the number of queue processes to 0 - if you do not set the number of AQ = time manager processes to 0 - if anybody is logged in apart from you.This = error message is misleading. The command requires the database to beopen but = only one session, the one executing the command, is allowed.The above method = will only work if the old character set is US7ASCII (or if you change the character set to itself). If the old character set is neither US7ASCII = nor equal to the new character set, the ALTER DATABASE [NATIONAL] CHARACTER = SET command will return: > -----Oorspronkelijk bericht----- > Van: paquette stephane [SMTP:stephane_paquette@yahoo.com] > Verzonden: 15-dec-00 13:37 > Aan: Multiple recipients of list ORACLE-L > Onderwerp: Re: Character sets >=20 > Hi, >=20 > There is not.=20 > You must export, rebuild and import. >=20 > Another thing, I'm not sure but I think that > WE8ISO8859P1 does not allow the Euro symbol. >=20 > HTH > --- lerobe - Lee Robertson a > =E9crit=A0: > All, > > =20 > > I have been made aware of a problem at our site. > > =20 > > Apparently we have a DB that was historically > > created with the wrong > > character set. It should be WE8ISO8859P1 but has > > been set at US7ASCII. The > > DB needs to be able to support German characters > > (such as =FC, =F6, =DF). Please > > tell me there is a way around this other than > > recreating the entire database > > (it is a fairly large DB). > > =20 > > TIA=20 > > =20 > > Lee Robertson=20 > > Acxiom=20 > > Tel: 0191 525 7344=20 > > Fax: 0191 525 7007=20 > > Email: lerobe@acxiom.co.uk=20 > > =20 > >=20 > >=20 > > The information contained in this communication is > > confidential, is intended only for the use of the > > recipient > > named above, and may be legally privileged. If the > > reader=20 > > of this message is not the intended recipient, you > > are > > hereby notified that any dissemination, distribution > > or > > copying of this communication is strictly > > prohibited. =20 > > If you have received this communication in error, > > please=20 > > re-send this communication to the sender and delete > > the=20 > > original message or any copy of it from your > > computer > > system. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: lerobe - Lee Robertson > > INET: LEROBE@acxiom.co.uk > >=20 > > Fat City Network Services -- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: ListGuru@fatcity.com (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). >=20 >=20 > =3D=3D=3D=3D=3D > Stephane Paquette > DBA Oracle > stephane_paquette@yahoo.com >=20 > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Thousands of Stores. Millions of Products. > http://shopping.yahoo.com/ > --=20 > Please see the official ORACLE-L FAQ: http://www.orafaq.com > --=20 > Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D > INET: stephane_paquette@yahoo.com >=20 > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing = Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L