Re: Create Index error
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 17 Feb 2010 20:59:38 +0100
Message-ID: <4b7c4aa6$0$22945$e4fe514c_at_news.xs4all.nl>
Op 17-2-2010 14:33, Vladimir M. Zakharychev schreef:
> On Feb 17, 2:00 pm, Reny<renato.esch..._at_gmail.com> wrote:
>>
>> I recently change charset from WE8ISO8859P1 to AL32UTF8, I have
>> restarted oracle, I have dropped all table, so I recreate schema and I
>> got the error.
>
> How exactly did you change the charset? This is pretty tricky process
> with many caveats and what you see is most probably result of database
> charset conversion done improperly.
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Date: Wed, 17 Feb 2010 20:59:38 +0100
Message-ID: <4b7c4aa6$0$22945$e4fe514c_at_news.xs4all.nl>
Op 17-2-2010 14:33, Vladimir M. Zakharychev schreef:
> On Feb 17, 2:00 pm, Reny<renato.esch..._at_gmail.com> wrote:
>>
>> I recently change charset from WE8ISO8859P1 to AL32UTF8, I have
>> restarted oracle, I have dropped all table, so I recreate schema and I
>> got the error.
>
> How exactly did you change the charset? This is pretty tricky process
> with many caveats and what you see is most probably result of database
> charset conversion done improperly.
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
And even more bad news: you probably can't change it back this way either.
Shakespeare Received on Wed Feb 17 2010 - 13:59:38 CST