Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> import to UTF8
Hi,
I try to import some tables from
a base:
8.1.7, AIX, WE8ISO8859P1
to another base:
8.1.6 HP-UX, UTF8
I have the following error :
what is wrong ?
Thanks in advance
oracle_at_disney:/var/tmp$ env|grep NLS
NLS_LANG=american_america.we8iso8859p1
oracle_at_disney:/var/tmp$ imp system/manager file=product.dmp log=prod.lo>
Import: Release 8.1.6.0.0 - Production on Mon Nov 25 17:35:44 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
Warning: the objects were exported by DSTMP, not by you
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set import server uses UTF8 character set (possible charset conversion) IMP-00069: Could not convert to environment national character set's handle IMP-00000: Import terminated unsuccessfully Received on Mon Nov 25 2002 - 14:46:24 CST