Re: Database character set change

On Sat, 25 Aug 2001 16:24:55 +0300, Phivos <phivos_at_NO.mpriki.photonics.ntua.gr.SPAM> wrote:

>Στις Fri, 24 Aug 2001 14:27:07 +0300, avm_at_trais.com.ua - aka Anatoly
>Moskovsky, έγραψε...
>
>
>>
>> Yes, it is possible. However it is not documented and I don't know if it
>> work with 8.1.5
>>
>
>
>It worked!
>
>Thank you, thank you, thank you!!!
>
>I was desperated that I had to rebuild everything from scratch, because
>EL8ISO8859P7 isn't a superset of WE8ISO8859P1 and I couldn't use the
>ALTER DATABASE SET NLS_CHARACTERSET instruction...
>
>Phivos.

Directly updating the dictionary invalidates any support contract. As you are, however, running a desupported version, in your case that probably doesn't make much difference.
Just a warning for anyone wanting to apply the above advice on a supported version: don't do it. There are procedures for it, and they work.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sun Aug 26 2001 - 02:09:10 CDT