Re: Changing character set

From: <bvalent_at_my-dejanews.com>
Date: Mon, 26 Apr 1999 02:10:17 GMT
Message-ID: <7g0hu8$969$1@nnrp1.dejanews.com>

Keep in mind, if by chance you should misspell the new characterset, you will not be able to reopen the database. Changing prop$ is very unsupported, so just keep it in mind.

Beth

In article <925071560.20191.0.muttley.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> Hi
> Yes, but unsupported of course. There is a sys table called prop$. One of
> the attributes is the character set of the database. It has been discussed
> in this newsgroup several times.
> I would recommend searching the dejanews archives.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Gocha Mchedlishvili wrote in message ...
> >Hi,
> >
> >I have ORACLE 7.3.4 DB on SunOS 5.6
> >When I created database by mistake I created it wit ASCII character set,
> but
> >now we need to use some characters from WE... character set. I found
> >information about changing the charcter set for ORACLE 8i database , but
> >didn't find any for ORACLE 7.3 database. Oracle support told that only
> >possible way to do this is recreate the Database.
> >Is it possible to avoid database recreation?
> >
> >Thank you
> >
> >Gocha
> >
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Apr 25 1999 - 21:10:17 CDT