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!

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 2 &nbspReplies

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

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

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 ?

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 .

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy