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

Thread: urgent

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    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
    Location
    Belgium
    Posts
    342
    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.

    key : HKEY_LOCAL_MACHINE\Software\ORACLE\ORA_NLS32
    value : %ORACLE_HOME%\NLSRTL32\DATA

    key : HKEY_LOCAL_MACHINE\Software\ORACLE\NLSRTL32
    value : %ORACLE_HOME%\NLSRTL32

    Hope this helps
    Gert

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