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.