Re: how do i change the NLS_CHARACTERSET -inside- a DB

Michael S. Abbey wrote:

> On Thu, 04 Jun 1998 18:17:01 +0200, "Thies C. Arntzen"
> <thies_at_digicol.de> wrote:
>
> >hmm,
> >i got a database in front of me (8.0.4) which is set to WE8ISO8859P9 as
> >it's character set, i now want to change this to WE8ISO8859P1 (for
> >western europe). there are no P9 specific chars in the DB so i won't
> >loose anything! - but i NEED to switch to P1 in order to get some weird
> >german typographics-apostophes in and out.
> >
> >i heard of some undocumeted thing that allows one to do this, can
> >anybody help me?!?!?
> >
> >regards,
> >tc
> >
> >PS: a copy thru e-mail would be nice....
>
> While logged on as sys enter the following command
>
> update props$ set value$= 'WE8ISO8859P1' where name =
> 'NLS_CHARACTERSET';
thanx, but.......this doesn't work with oracle 8.x ;-))) (the props$ table is still there and you can change the value, but you cannot start the DB afterwards;-) spoke to oracle support, they confirmed this (and said it was possible to do so with 7.x). they said it might be possible with alter database.... but i don't know the heck how to do that....

anybody solved this problem before (with oracle 8.x)?!?!?!

regards,
tc

>
>
> Be sure the value you change it to is correct,; anything will be
> accepted by SQL*Plus but, if an invalid value is entered, you will ne
> able to shut but NEVER AGAIN start that database!
>
> Michael
>
> +------------------------------------
> + Michael S. Abbey Ottawa Canada
> + Co-author of Oracle8: A Beginner's Guide
> + and 5 other works in the Oracle Press Series
> +------------------------------------
Received on Fri Jun 05 1998 - 05:15:09 CDT