Skip to Main Content
  • Questions
  • Importing data from file to oracle databse via command prompt

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, sateesh.

Asked: September 20, 2016 - 9:31 am UTC

Last updated: September 20, 2016 - 5:36 pm UTC

Version: 11.2.0

Viewed 1000+ times

You Asked

Hi Experts,

I am trying to load data from file into oracle database via command prompt throwing error like

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

I installed oracle 11g 64 BIT in my local system,checked language and character set

NLS_LANGUAGE NLS_CHARACTERSET
AMERICAN WE8MSWIN1252

Could you please help me.

Thanks,
Sateesh

and Connor said...

Normally this is a misleading error - one of the *first* things we do when runnign import is try derive metadata (like the characterset) from the header information in the file.

If the file is corrupted, or from the wrong version of exp, or was done with expdp etc...ie, anything that makes the file no longer suitable, then we can't find the characterset info and report this error.

So double check your file, and where it was sourced from.

Hope this helps.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

sateesh, September 22, 2016 - 3:04 pm UTC

Hi Connor McDonald,

Thanks for the reply,file is in my local drive below is the cmd used,

D:\gosalesdumpfile>imp supplier/supplier@orcl123 file=supplier2.dmp full=y log
=supplier.log
gosalesdumpfile is a directory,i placed supplier2.dmp file in that.

Thanks,
sateesh

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.