Oracle: Can a character set be changed after a schema has been created?

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:

Answer Wiki

Thanks. We'll let you know when a new response is added.

Character Sets are determined at the time you create your database and are set for the entire 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

Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • JennyMack
    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
    4,280 pointsBadges:
  • carlosdl
    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 .
    85,925 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: