Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user12845040Nov 14 2013 — edited Nov 16 2013

The export was done in linux. I am told their settings are: (i can not verify)

NLS_CHARACTERSET AL32UTF8

NLS_NCHAR_CHARACTERSET AL16UTF16

exporting from version

Export: Release 11.2.0.3.0

I am trying to import it into an empty database in windows with version Release 11.2.0.1.0 (a few patch levels lower)

NLS_CHARACTERSET AL32UTF8

NLS_NCHAR_CHARACTERSET AL16UTF16

select userenv('LANGUAGE') from dual

AMERICAN_AMERICA.AL32UTF8

my environment var for NLS_LANG=AMERICAN_AMERICA.AL32UTF8

The KEY_HKLM\Software\oracle\OraDb11g_home1\NLS_LANG value is also set to AMERICAN_AMERICA.AL32UTF8

imp prod_user/password@instacnename file=exportfile.dmp show=y

WITH JUST SHOW=Y ON ..(same with it off)

Import: Release 11.2.0.1.0 - Production on Thu Nov 14 11:09:51 2013

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

Production

With the Partitioning option

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

IMP-00000: Import terminated unsuccessfully

ANY idea how to resolve this? I have re-transmitted the file and un gziped it again.. to be sure the xfer was not the issue..

I am stumped.. I have searched the forums and web and tried most of what I found.

Thanks in advance

-Ken

This post has been answered by Richard Harrison . on Nov 15 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2013

Added on Nov 14 2013

#database-key-features, #export-import-sql-loader-external-tables

15 comments

77,476 views