DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: urgent

Hybrid View

  1. #1
    Join Date
    Sep 2000
    i m getting this problem while importing the
    export file
    IMP-00038: Could not convert to environment character set's handle
    IMP-00000: Import terminated unsuccessfully
    why it is comming and what will be the solution
    can anybody will help me to sort out this problem
    this is very urgent
    os is windows NT

  2. #2
    Join Date
    Aug 2000
    I searched on metalink, most of the time the problem was an incorrect ORA_NLS setting.

    I also find a forum entry.
    Here's what they say :

    Subject: Failed to migrating a database from UNIX to NT

    RDBMS Version: 8.0.5
    Operating System and Version: Windows NT 4.0 / HP UX
    Error Number (if applicable): IMP-00038
    Product (i.e. SQL*Loader, Import, etc.): Import
    Product Version: 8.0.5

    Failed to migrating a database from UNIX to NT

    I tried to import data from an exported dump which was produced by
    one of our clients. The exported dump was a full database dump
    from a HPUX box. Now, I want to load it into my NT machine and I received the error
    IMP-00038: Could not convert to environment character set's handle.

    The source server uses the default NLS_LANG and is an Oracle7.3.4
    server. My Oracle uses the default NLS_LANG(AMERICA) and is an Oracle
    8.0.5. The exported dump was saved to a CD and sent to us.

    I read the Oracle Messages and codes manual and I could find any
    explanation about the error IMP-00038.

    Any idea?


    Subject: Re : Failed to migrating a database from UNIX to NT

    There could be a couple of causes for this error.

    Check your NT registry for the variables ORA_NLS33 and NLSRTL33 in Hkey_local_machine/software/oracle. These should be set to
    %oracle_home\nlsrtl33\data and %oracle_home%\nlsrtl33 respectively.

    My guess is that the UNIX database is using a 7-bit characterset and your NT database is 8-bit based on what would be the defaults. Set the registry variable NLS_LANG to the character set of the export dump
    file. This is probably US7ASCII but you can check this by selecting from v$nls_parameters. This doesn't reflect the value of the NLS_LANG characterset but the characterset the database was created with.

    Once you have imported the 7-bit characterset data, you should set your NLS_LANG back to the characterset of the database.


    I also looked at the registry off an NT server with ora 734.


    value : %ORACLE_HOME%\NLSRTL32

    Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width