Could not convert to character set's handle

Posted on 2005-05-17
Last Modified: 2008-01-09
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,

Question by:muskware77
    LVL 9

    Expert Comment

    Check the characterset of your source and destination
    SQL> select * from props$ where name='NLS_NCHAR_CHARACTERSET' or name='NLS_CHARACTERSET';
    LVL 9

    Assisted Solution

    Change your local character set with the source one.
    either by chaging in init.ora file
    SQL>ALTER DATABASE SET NLS_NCHAR= <source char set>;
    LVL 4

    Accepted Solution

    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.
    LVL 2

    Author Comment

    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_.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now