Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> import to UTF8

import to UTF8

From: zeb <thierry.constant1_at_free.fr>
Date: Mon, 25 Nov 2002 21:46:24 +0100
Message-ID: <3de28bef$0$23000$626a54ce@news.free.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US