Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Change charset of database
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
![]() |
![]() |