Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how do i change the NLS_CHARACTERSET -inside- a DB

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

From: Michael S. Abbey <masint_at_istar.ca>
Date: Thu, 04 Jun 1998 22:38:34 GMT
Message-ID: <357721d6.26255683@news.istar.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US