Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004

    Unanswered: Problem while importing, Very Urgent

    Hi All

    I have two Oracle servers
    1) Oracle 9.2. on SUN SOLARIS(machine 1)
    2) Oracle 9.2. on SUN SOLARIS(machine 2)

    I exported a user from machine 1, and when i try to import it in
    machine 2, i'm getting the following error

    IMP-00067: could not convert the server character set's handle.

    I'm not even able to export any user from machine 2, when i tried to export, i'm getting Oracle Error 3106.

    Can any one help me out, it is urgent.

    Many Thanks

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    My first guess is that each database is using a different NLS character set...
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    I agree ... reading this forum, it seems that many problems during import are solved by correcting NLS character set.

  4. #4
    Join Date
    Dec 2004
    Apeldoorn, the Netherlands
    This is the official text from metalink:

    Error: IMP 67 Text: Could not convert to server character set's handle
    --------------------------------------------------------------------------- Cause: Internal error.
    Action: Contact Worldwide support

    Not very helpfull..

    I searched a bit further, but I could only find situations with this errors which involves creating a repository on a 8i database, and client-pc's which are missing required support files for the WE8ISO8859P15 character set..

    But as it seems, check your NLS_LANG settings on both machines.

  5. #5
    Join Date
    Jul 2003
    What are the NLS_LANG settings on both servers?
    why would they be different?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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