Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not able to import hindi font data properly while importing oracle dump.

User_GMJGCJun 1 2022 — edited Jun 1 2022

I'm stuck on one problem and it is that while importing oracle dump, I'm not able to restore hindi font data properly even when character set is same for source and destination. So is there any solution where i can restore Oracle dump with hindi font data in a proper way? I'm using oracle 11g enterprise edition.
I am using the following command to import dump file in oracle :
$impdp system/*** schemas=BANK directory=BANK dumpfile=FULLDB_01052021.DMP logfile=BANK.log
So the rows count get match after the import. But the data with in the Hindi font comes with some junk values which is आदमीन exp but it should be 'आदमीन exp' for the junk values. See the attachament
o2 (2)_LI.jpg
Please let me know what I can do??
Thank you in advance.