• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8595
  • Last Modified:

Could not convert to character set's handle

Hello experts,

I received a .dmp file from a customer and try to load it with the Import utility. However, the import systematically terminates unsuccessfully with error IMP-00038:

"Could not convert to character set's handle."

I have tried to change my NLS_LANG variable on the PC (registry of MS Windows 2000) to the following values: DUTCH_THE NETHERLANDS.WE8ISO8859P1 then AMERICAN_AMERICA.WE8ISO8859P1. Then i boot the PC. The error still is not resolved.

Any idea/tip will be very much appreciated.

Best regards,

muskware77
0
muskware77
Asked:
muskware77
  • 2
2 Solutions
 
MetanilCommented:
Check the characterset of your source and destination
SQL> select * from props$ where name='NLS_NCHAR_CHARACTERSET' or name='NLS_CHARACTERSET';
0
 
MetanilCommented:
Change your local character set with the source one.
either by chaging in init.ora file
or
SQL>ALTER DATABASE SET NLS_NCHAR= <source char set>;
0
 
plamen73Commented:
when the dmp file has been made, the oracle export utility has made a conversion from the DB character set to the machine where the export took place character set.
Now you have to do exactly the same: Set the machine character set (in the registry - something like Sofware/ORACLE/HOME0/NLS_LANG) to be the same as on the machine where the export has been made. Also if you have an environment parameter NLS_LANG at the OS level remove it.
And the second prerequisite is to have the same DB character set as it was at the source DB, or compatable. Unfortunately this can be set only at installation time. So, you can only hope your DB character set is compatable with the source one.
0
 
muskware77Author Commented:
Thanks everyone for your input.

We got another dump from the customer and could import the data.

However i split the points between _metanil_ and _plamen73_.

Cheers,
muskware
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now