Re: How to change the character set

Hello,

You did not say Oracle version you are running. Anyway, there is a table named props$ in SYS schema. You can update that table and set character set for your database you would like to.
For example as user sys run:
  update props$ set value$='CL8MSWIN1251' where name = 'NLS_CHARACTERSET';
After that restart your database and it will run with new characterset. Just remember, if you made a mistake and put not exist characterset you will not able to start database. All your already saved data in the database will not useful.

Regards.
Zasp.

"Alex Ivascu" <alexdivascu_at_yahoo.com> wrote in message news:gAOr8.119568$QB1.28185909_at_typhoon3.we.ipsvc.net...
> If conversion is possible, you can change your character set during the
> import process, by setting the NLS_LANG=character_set_preferred
environment
> variable. Otherwise, I suggest you re-create your database using the same
> character set...
>
> Alex Ivascu
> DBA
>
>
> "Time Vest Insurance" <reb_at_timevest.com> wrote in message
> news:l8zelhu57di.fsf_at_timevest.com...
> >
> > I'm loading in a Customer Database in order to test an
> > application. I'm unable to load the dump because the character set my
> > Oracle Server is set for is different that the character set of the
> > dump.
> >
> > How do I change my character set?
> >
> > Bob
>
>
Received on Sun Apr 07 2002 - 21:59:01 CDT