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
<do a full database backup>
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 <new_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_at_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 <LEROBE_at_acxiom.co.uk> 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_at_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_at_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_at_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_at_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_at_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_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Fri Dec 15 2000 - 07:02:11 CST
