I export dump from oracle database 8.1.7 and try to import in 10.2.0. while import its prompt error

Advertisement
I export dump from oracle database 8.1.7 and try to import in 10.2.0. while import its prompt error as follow
8.1.7
SQL> select * from nls_database_parameters where parameter like '%SET%';
PARAMETER                      VALUE
NLS_CHARACTERSET               US7ASCII
NLS_NCHAR_CHARACTERSET         US7ASCII
10.2.0
SQL> select * from nls_database_parameters where parameter like '%SET%';
PARAMETER                      VALUE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_CHARACTERSET               WE8MSWIN1252
C:\Documents and Settings\Administrator>imp system/manager file=H:\CGlByte\cglby
te_03-07-2013Wed.dmp fromuser=system touser=cglbyte ignore=y
Import: Release 10.2.0.4.0 - Production on Thu Jul 4 16:11:49 2013
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V08.01.07 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
Import terminated successfully without warnings.
Pl suggest remedy
Regards,
Advertisement

Replay

8.1.7
AMERICAN_AMERICA.WE8ISO8859P1
10.2.0
AMERICAN_AMERICA.WE8MSWIN1252
exp system/manager file=d:\cgl.dmp owner=cgl, even i set character set before export but no impact