I have importing from 8.1.6 version. and the xported file from 8.1.7.
it is also showing some NCHAR charecter set.
actually its a version probel....or what..
the msg is.
$ imp al/pw4al file=algo.dmp
Import: Release 18.104.22.168.0 - Production on Fri Dec 20 09:57:22 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 22.214.171.124.0 - Production
With the Partitioning option
JServer Release 126.96.36.199.0 - Production
Export file created by EXPORT:V08.01.07 via conventional path
import done in US7ASCII character set and US7ASCII NCHAR character set
IMP-00069: Could not convert to environment national character set's handle
IMP-00000: Import terminated unsuccessfully
Check your national character set(nchar) at then if its not us7ascii
ALTER DATABASE SET NATIONAL
That should hopefully fix it.
Also, read the following note 181508.1
Last edited by jlakhani; 12-19-2002 at 11:29 AM.
"High Salaries = Happiness = Project Success."
have you exported using exp 8.1.6 and imported with imp 8.1.6?
change your NLS_LANG to a proper one, you have to see that from the server where you exported
Click Here to Expand Forum to Full Width