Oracle: Can a character set be changed after a schema has been created?
Home > IT Answers > Oracle > Oracle: Can a character set be changed after ...
DeloeranGuy
55 pts.
0
Q:
Oracle: Can a character set be changed after a schema has been created?
Oracle 10.2.0.1.0, Oracle 10
My boss was so pleased with the response from this site that he asked me to ask another question!  He was getting character set warnings when doing an export, apparently the charset of his db was different than where he was exporting (I think!).

In any case, we build a new db (schema) prior to loading it with data.  Is there a way to change the character set on a new, empty db to prevent any errors?  Is there some command we can use?

Thanks again!



Software/Hardware used:
Oracle 10.2.0.1.0
ASKED: Oct 22 2009  3:06 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
FlaviusMaximus
180 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Character Sets are determined at the time you create your database and are set for the entier database, not a single user. It is possible to migrate from one character set to another using export/import if conditions are correct.

Here is the documentation link that explains it. I would post more info but you will get it when you read the documentation. Unfortunately, character sets are a sensitive component to oracle and there is no quick answer. You will need to read the documentation.

You will notice there is a section on how to change your character set.

Good luck, Kevin
Last Answered: Oct 22 2009  6:35 PM GMT by FlaviusMaximus   180 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

JennyMack   3330 pts.  |   Oct 22 2009  4:19PM GMT

Hey DeloeranGuy,

Glad to hear you’re finding the site useful! Your boss can always sign up too =)

Welcome to the community,

Jenny
Community Manager

 

Carlosdl   29845 pts.  |   Oct 22 2009  6:08PM GMT

Some clarification is needed here.

A new schema is not a new database (and the character set is a property of the database, not the schema), so, did you create a new schema in the same database, or are they in different database servers ?

What do you get if you run this command from both databases ?

select * from nls_database_parameters
where parameter = ‘NLS_CHARACTERSET’;

If you get the same value from both databases, then there is probably no need to change the character set unless the current character set does not support all the languages you need to support. Maybe you just need to change the character set on the OS, to avoid the characterset conversion when performing the export .

 
0