Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how do i change the NLS_CHARACTERSET -inside- a DB
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'; 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 Thu Jun 04 1998 - 17:38:34 CDT
![]() |
![]() |