Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: change db character set
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