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

  • by

IMP-00038

I thought it was a character set conversion problem when using the original import (imp) to import a dump file, so I tried to change correct character set for later import. But IMP-00038 is still there.

D:\app\oracle\admin\ORCL\dpdump>imp \"/ as sysdba\" FROMUSER=ERPAPP IGNORE=y FILE=exp_demo.dmp LOG=imp_demo_meta_20200902-1.log

Import: Release 12.1.0.2.0 - Production on Thu Sep 1 21:45:32 2020

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


Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

IMP-00038: Could not convert to environment character set's handle
IMP-00000: Import terminated unsuccessfully

Solution

It turns out to be that I used original imp to import a dump file that was generated from data pump. The solution is to go back to use impdp utility of data pump.

On the contrary, if you use impdp, a data pump utility, to import a dump file that was generated from the original exp, you will get ORA-39143: dump file may be an original export dump file.

Leave a Reply

Your email address will not be published. Required fields are marked *