This discussion is archived
9 Replies Latest reply: Jul 3, 2013 6:43 AM by rukbat RSS

Importing Database

746886 Newbie
Currently Being Moderated
hi,

i have a backup file taken from a server running in Linux.

when i try to import in a windows mechine it is showing error : IMP-00038: Could not convert to environment character set's handle

DATABASE NLS PARAMETERS are set as the linux mechine.

Can any body help me with this?

Thanks and Regards,

Joseph
  • 1. Re: Importing Database
    FahdMirza Oracle ACE
    Currently Being Moderated
    What is the version of your database?
  • 2. Re: Importing Database
    FahdMirza Oracle ACE
    Currently Being Moderated
    Also,

    Set environment variable NLS_LANG to the character set of the export file

    regards
  • 3. Re: Importing Database
    Antonio Navarro Pro
    Currently Being Moderated
    Did you ftp in binary mode? Have you try import remotely?
  • 4. Re: Importing Database
    CKPT Guru
    Currently Being Moderated
    when i try to import in a windows mechine it is showing error : IMP-00038: Could not convert to environment character set's handle

    DATABASE NLS PARAMETERS are set as the linux mechine.
    Look for NLS_LANG from your system where you are performing..

    IMP-00038: Could not convert to environment character set's handle
    Cause: Internal error.
    Action: Contact Worldwide Support. :(


    JosephJ

    Handle: JosephJ
    Status Level: Newbie
    Registered: Jan 15, 2010
    Total Posts: 26
    Total Questions:  9 (8 unresolved)

    Close the threads if ansered.

    Edited by: CKPT on Dec 11, 2010 7:17 AM
  • 5. Re: Importing Database
    918231 Newbie
    Currently Being Moderated
    do we need to change language setting in oracle ? to fix this problem ?
  • 6. Re: Importing Database
    1012878 Newbie
    Currently Being Moderated

    i am having the same issue. i installed oracle 11g on windos

     

     

     

    SQL> $IMP

     

     

    Import: Release 11.2.0.1.0 - Production on Wed Jul 3 18:10:06 2013

     

     

    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

     

     

    Username: qvs

    Password:

     

     

    Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit

    Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

     

     

    Import data only (yes/no): no >

     

     

    Import file: EXPDAT.DMP > C:\Users\Onkar\Desktop\EXPDAT.DMP

     

     

    Enter insert buffer size (minimum is 8192) 30720>

     

     

    IMP-00038: Could not convert to environment character set's handle

    IMP-00000: Import terminated unsuccessfully

     

    how can i solve this problem.

     

    Thanks

    Chandrashekhar

  • 7. Re: Importing Database
    DK2010 Guru
    Currently Being Moderated

    please donot use  3  Yr Old thread for Your Question.

    open new thread for your Query

  • 8. Re: Importing Database
    1012878 Newbie
    Currently Being Moderated

    How to open new thread for my  Query.please help




    Thanks

  • 9. Re: Importing Database
    rukbat Guru Moderator
    Currently Being Moderated

    Moderator Action and Advice:

    1012878 wrote:

    How to open new thread for my  Query.please help

    Stay with your other forum post:

    https://forums.oracle.com/thread/2556462

    You already figured how to start that one on your own.

     

    For the future, you should have more patience when you join a forum site.

    Spend time getting familiar with the layout instead of just splattering your questions any old place.

     

    For example, do not EVER hijack someone else's thread for your own question. 

    ALWAYS start a new thread, just as you did in what I have linked.

     

    This old one is now locked to let it return to its zombie slumber.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points