Q
Problem solve Get help with specific problems with your technologies, process and projects.

Problems with exporting database after modifying database characterset

I am running Oracle 8.1.6 on HP Unix. Earlier, we were using a different character: American_America.AR8ISO8859P6....

Due to client requirements we have changed the character in Unix Server in .profile and Props$ table to American_America.AR8MSWIN1256. Is there any other file we need to change in order to change the character set?

When I run the export command to export the database, there are some errors. The infomation displayed is below:

. exporting synonyms
EXP-00008: ORACLE error 6553 encountered
ORA-06553: PLS-561: character set mismatch on value for parameter 
'SHORTNAME'
EXP-00000: Export terminated unsuccessfully 

Could you tell me why this is happening?

It is not advisable to change the SYS.PROPS$ table directly. To change your database's character set, you should use the ALTER DATABASE command. After successful completion of this command, the appropriate Data Dictionary tables will be updated for you. There is a chance that manually updating this table can cause a problem for you.

Unfortunately, the AR8MSWIN1256 characterset is not a binary superset of the AR8ISO8859P6, so conversion is not a simple task. The code points are different between the two. The recommended method to convert your database's characterset is to export the entire database, recreate the database with the new characterset, then perform a full import. Metalink Note:260022.1 has details on how to convert the database characterset without performing the export/import operation.

Please modify your database's characterset correctly. After successful completion, your export problems should go away.

This was last published in November 2004

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close