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 -> Re: import to UTF8

Re: import to UTF8

From: Andy Hassall <andy_at_andyh.org>
Date: Tue, 26 Nov 2002 00:28:58 +0000
Message-ID: <92g5uug0g9n2dojohquu0tc3fig2lijcnv@4ax.com>


On Mon, 25 Nov 2002 21:46:24 +0100, "zeb" <thierry.constant1_at_free.fr> wrote:

>Import: Release 8.1.6.0.0 - Production on Mon Nov 25 17:35:44 2002
>
>Export file created by EXPORT:V08.01.07 via conventional path

 That won't be compatible - you should have used the lower version exp to produce the dump file.

>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)

 Should be OK on the character set front, since everything in ISO8859P1 should be convertible to UTF8 (but careful about the bytes vs. character issues).

>IMP-00069: Could not convert to environment national character set's handle
>IMP-00000: Import terminated unsuccessfully

 This is misleading at a glance - it's caused by the incompatible versions of imp/exp rather than an actual character set issue.

-- 
Andy Hassall (andy@andyh.org) icq(5747695) http://www.andyh.org
http://www.andyhsoftware.co.uk/space | disk usage analysis tool
Received on Mon Nov 25 2002 - 18:28:58 CST

Original text of this message

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