-
Import Problem
Hi
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 8.1.6.0.0 - Production on Fri Dec 20 09:57:22 2002
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.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
then
ALTER DATABASE SET NATIONAL
CHARACTERSET "US7ASCII"
That should hopefully fix it.
Also, read the following note 181508.1
-
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