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

Problem Description:
Import fails with
IMP-00038: Could not convert to environment character set's handle
IMP-00000: Import terminated unsuccessfully
Solution Description:
  1. In most of the cases this error occurs when you take an export using expdp utility and trying to import the dump with conventional imp utility. Make sure you have taken the export with exp utility.
  2. If you have done any kind of export dump file transfer make sure that you have done in BINARY mode.
  3. Check any kind of dump file manipulation has been performed or not.
  4. Make sure your compress/uncompress gzip/gunzip is done properly
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google