I have a DMP file exported from a Simplified Chinese Character Set Oracle DB. But I need Import this DMP file into a Oracle DB with defferece character Set(eg. Tranditional Chinese Character Set). Please tell me whether or not there are some method to do it. Thanks!
An export file that is produced with a multi-byte character set (for example, Chinese or Japanese) must be imported on a system that has the same character set or where the ratio of the width of the widest character in the import character set to the width of the smallest character in the export character set is 1. If the ratio is not 1, Import cannot translate the character data to the Import character set.
I never tried before . But I think possible or not , it's depandant on how you input numberic and special chars (like '*=') into the varchar2 column . If the numberic and
special char are also stored as 2 chars which is same as simplific chinese . Then the conversion is possible .
I remeber that for Simplific Chinese Env. There are
two kinds to input the numberic and special char into varchar2
. One is just use Ascii , which is 1 char , Another is using Simplific Chinese input , which is stored as 2 chars .
Converison is only possible in the second case .
Anyway , If anybody has done before , please let me know .