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

advertisements

_____________________________________________________________________________________________________________________

Problem Description:

Import fails with

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

IMP-00000: Import terminated unsuccessfully

Solution Description:

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.
If you have done any kind of export dump file transfer make sure that you have done in BINARY mode.
Check any kind of dump file manipulation has been performed or not.
Make sure your compress/uncompress gzip/gunzip is done properly

_____________________________________________________________________________________________________________________

A visitor from Bourgogne viewed 'How to Force Oracle RMAN to Delete All Archive log' 2 hrs 1 min ago

A visitor from Hamburg viewed 'Fix IMP-00013: only a DBA can import a file export' 2 hrs 28 mins ago

A visitor from India viewed 'Oracle NO_INDEX hint: Syntax, Purpose and Example' 2 hrs 48 mins ago

A visitor from Gateshead viewed 'How to Automate / Schedule Oracle Gather Table Sta' 2 hrs 48 mins ago

Archive