OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » IMP-00038

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP-00038 [message #70651]

Wed, 10 July 2002 20:37

krishna
Messages: 141
Registered: October 1998

Senior Member

I needed to export a database from 8.1.7 to 8.1.6. So i ran the 8.1.6 catexp.sql on the 8.1.7 server and exported the database. When importing into the 8.1.6 server i got this error.
IMP-00038: Could not convert to environment character set's handle
What is the solution?

Report message to a moderator

Re: IMP-00038 [message #70653 is a reply to message #70651]

Wed, 10 July 2002 20:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1.if you are export from unix/solaris machine the exp.dmp
  should to ftp'ied with BIN option.
2.make sure that u set ORA_NLS 
  Set environment variable NLS_LANG to the character set of the export dump file
  make sure LD_LIBRARY_PATH is point correct ORACLE_HOME
3.make sure that u Use the EXP 8.1.6 to export the data from the
  8.1.7 database and IMPORT 8.1.6 to import the data
  into the 8.1.6 database

Report message to a moderator

Re: IMP-00038 [message #70668 is a reply to message #70651]

Thu, 11 July 2002 07:04

Grant
Messages: 578
Registered: January 2002

Senior Member

This isn't the way to handle this going down versions. Re-run 8.1.7 catexp.sql in the 8.1.7 database as sys.

From the 8.1.6 server:

exp system/manager@817tnsalias ...
imp ...

Report message to a moderator

Re: IMP-00038 [message #113443 is a reply to message #70653]

Sun, 03 April 2005 10:12

acpt
Messages: 12
Registered: April 2005

Junior Member

I tried importing Oracle 8.1.7 dump file into 8.1.6 database.
I got this error

Export file created by EXPORT:V08.01.07 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
IMP-00069: Could not convert to environment national character set's handle
IMP-00000: Import terminated unsuccessfully

When i checked the 'NLS_NCHAR_CHARACTERSET' & 'NLS_CHARACTERSET', I found they are the same as my dump file (WE8ISO8859P1)

SQL> select * from props$ where name='NLS_NCHAR_CHARACTERSET' or name='NLS_CHARACTERSET';

NAME VALUE$
------------------------------ ------------------------------------------------------------
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET WE8ISO8859P1

Please suggest whats the problem now ?

Regards,
Sanjay Kumar

Report message to a moderator

Previous Topic:	UTL_FILE problem - getting file in ascii format
Next Topic:	Migration Oracle 8i to 9.2.0.5 using exp/ imp (diff. machines)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 07:14:02 CDT 2024