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 -> Change charset of database

Change charset of database

From: zeb <thierry.constant2_at_wanadoo.fr>
Date: Sat, 8 Jun 2002 11:54:48 +0200
Message-ID: <3d01d3d6$0$252$626a54ce@news.free.fr>


Hi,

I have to change the charset of my database from WE8ISO8859P1 to UTF8

How can I do that ?

What I found are:
o If WE8ISO8859P1 is a subset from UTF8 I can use:
SHUTODWN IMMEDIATE
cold backup
STARTUP MOUNT
ALTER SYSTEM ENABLE RESTRICTED SESSION
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0
ALTER DATABASE OPEN
ALTER DATABASE CHARACTER SET UTF8
SHUTDOWN IMMEDIATE
STARTUP Is UTF8 a superset of W8ISO8859P1 ???

o if not:
cold backup
CONNECT SYS/...
UPDATESYS.PROP$ SET VALUE$ = UTF8 WHERE NAME = 'NLS_CHARACTERSET'; SHUTDOWN IMMEDIATE
STARTUP What is the right procedure ?

Have I to EXP/IMP the date after ????

Thanks for any correction, help , URL .... Received on Sat Jun 08 2002 - 04:54:48 CDT

Original text of this message

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