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!

impdp problem using AL32UTF8 with Arabic and English data,

749480Jan 31 2010 — edited Feb 5 2010

Dear Experts,
I have a problem with importing a data pump using impdp and I search this forum but I didn't found any solution to my problem.
I extracted a data pump files from an oracle 10g database using expdp command, but when I try to restore this dump on another machine running the same oracle version and the same OS, it imports the tables and indexes correctly but the Arabic data stored at this tables appears on undefined characters.
the database characterset is AL32UTF8 and the source database uses the same characterset, also I used NLS_LANG but It didn't solve any thing!
How can I solve this issue because I deleted the source database and I only have this dump file.
Please help me and thanks in advance.

Edited by: Ahmed Shaheen on Jan 31, 2010 9:48 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2010

Added on Jan 31 2010

#database-key-features, #globalization-support

7 comments

3,122 views