| Importing Problem [message #69707] |
Fri, 22 February 2002 19:32  |
kiran kumar
Messages: 17
Registered: June 2001
|
Junior Member |
|
|
hai,
I am getting the below error message when i try to import an exported dumpfile....there is oracle versions mismatch from the system where export took place and where import is taking place.
any workarounds for importing dump file
C:>IMP
Import: Release 8.1.5.0.0 - Production on Fri Feb 22 23:56:33 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Username: IFPMS/KSHIP@KIRAN
Connected to: Oracle8i Personal Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
Import file: EXPDAT.DMP > G:kshipdumpexpkship010202.dmp
Enter insert buffer size (minimum is 8192) 30720>
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
thanks in advance
kiran
|
|
|
|
| Re: Importing Problem [message #69719 is a reply to message #69707] |
Mon, 25 February 2002 06:29  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Make sure you have your NLS_LANG environment variable set to your NLS setting in the target DB. The example use WE but you may be using something else.
C:>set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
C:>imp
|
|
|
|
| Re: Importing Problem [message #70582 is a reply to message #69707] |
Wed, 03 July 2002 05:36 |
Sanal
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
Hi kiran,
The issue is mostly with the version of IMP exe you are using. Check the following:
Version of
1)source DB.
2)Dest. DB
3)exp
4)imp
regards,
Sanal
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
