Re: Characters losts during Import (8.1.6) -> (9.2.0.6)

From: Cris Carampa <cris119_at_operamail.com>
Date: Wed, 05 Jul 2006 14:46:51 +0200
Message-ID: <44abb4eb$0$976$5fc30a8@news.tiscali.it>

sybrandb wrote:

> It all depends on
> - correct NLS_LANG during export (ie matching the characterset of the
> database)
> - correct NLS_LANG during import (ie matching the characterset of the
> database)

I know this is the correct method, but going that way the OP would lose all the French characters, because, according to my experience, imp on the "target" database (which is WE8ISO8859P1) will truncate all the 8-bit characters of a US7ASCII export file during import. That's why I suggested SQL*Loader.

Kind regards,

-- 
Cris Carampa (spamto:cris119_at_operamail.com)

I went to the market to realise my soul
'Cause what I need I just don't have

Received on Wed Jul 05 2006 - 07:46:51 CDT