Re: Change charset of database

On Sat, 8 Jun 2002 12:16:31 +0200, "zeb" <thierry.constant2_at_wanadoo.fr> wrote:

>Sorry, the version is 8.1.7 on HPUX 11.0
>
>"zeb" <thierry.constant2_at_wanadoo.fr> a écrit dans le message de news:
>3d01d3d6$0$252$626a54ce_at_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 ....
>>
>>
>>
>>
>

Use version 2 if you want to loose support

I also think the sequence of commands in version 1 is incorrect and incomplete
I don't think the alter system is going to work before an alter database open.
I also think you'll need to add
alter database national character set UTF8

UTF8 is a superset of WE8ISO8859p1. Note: You can not change it *back*

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jun 08 2002 - 09:10:28 CDT