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

Home -> Community -> Usenet -> c.d.o.server -> Re: change db character set

Re: change db character set

From: Peter Gadah <pgadah_at_magicnet.net>
Date: 21 Apr 1999 04:09:30 GMT
Message-ID: <371D5084.C27F92F7@magicnet.net>


Wai,

The only "supported method" of changing your database's character set is to recreate the database.  You can specify the character set you wish to use in the "create database" statement.

Also, if you would like to determine what the character set has been set for your database, you should be able to find this out querying against the sys.props$ table.

Once you've recreated the database, export from your original database, and finally import into the newly created database.

Hope that helps.
Regards,
Peter

Wai wrote:

> I have create a database and have lot of data in it.
>
> Can I change the character set of the db?
> If yes, how can I do that? Is there any tool to help me?
>
> I am running oracle server 8.0.4 with win NT server 4 sp3
Received on Tue Apr 20 1999 - 23:09:30 CDT

Original text of this message

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