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 ....
>
>
>
>
Received on Sat Jun 08 2002 - 05:16:31 CDT
