question

OracleApprender avatar image
OracleApprender asked

Possibility to Change CHARACTERSET of a database ?

Can anybody tell me, whether we can change the CHARACTERSET of a database. If yes then please explain me the way ?

queryoracleplsql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
coskan avatar image
coskan answered

I don't know your DB version

Please refer to MOS note [ID 234381.1]

Basically it could be done for versions up to 8i this option looks still available but Oracle says do not do it and create database again with right characterset and do export import. Data loss is highly possible if you go 8i way.

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image HillbillyToad commented ·
Yeah, this is a decision you want to make right at the time you create the database. If you don't have any data, then it's probably no bid deal to change it.
0 Likes 0 ·
OracleApprender avatar image OracleApprender commented ·
I'm using 9i version. As per my knowledge there is no possibility of changing the CHARACTERSET of a database once it is created. Still want to know if any possibility exists for this.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.