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 -> exp/imp and NLS

exp/imp and NLS

From: astalavista <spam_at_nowhere.com>
Date: Thu, 24 Mar 2005 21:09:52 +0100
Message-ID: <424320f4$0$2698$626a14ce@news.free.fr>


Hi,

I have to transfert a schema
from a DB 9i to a new DB 8i,
unfortunately the DB9 is in AL32UTF8

I use the exp/imp binaries of DB8, I did the exp/imp from the DB8 machine

I tried a lot of combinaisons:
exp:
NLS=UTF8
NLS=US7ASCII I created the DB8
UTF8
WE8ISO88591
US7ASCII imp:

NLS=UTF8
NLS=US7ASCII
NLS=WE8ISO8859P1

with no success, with errors like :

Export file created by EXPORT:V08.01.07 via conventional path import done in UTF8 character set and US7ASCII NCHAR character set import server uses US7ASCII character set (possible charset conversion) IMP-00067: Could not convert to server character set's handle IMP-00000: Import terminated unsuccessfully

What is the right combinaison ???
I have no special characters in DB9
Can you help me ???
Thanks in advance ... Received on Thu Mar 24 2005 - 14:09:52 CST

Original text of this message

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