Re: Warning during import
From: joel garry <joel-garry_at_home.com>
Date: Tue, 12 Oct 2010 09:13:07 -0700 (PDT)
Message-ID: <1bfb35ac-8bb4-4ffb-99b9-23e8a70fb01a_at_q28g2000prb.googlegroups.com>
On Oct 9, 4:14 am, "bob123" <nom..._at_nowhere.com> wrote:
> Hi,
>
> when we import with a character set different from the database
> we have the follwing error (from memory):
>
> import done in ...
> server server uses ...
> export client uses ...
> export server uses
> conversion ...
>
> Is it a real pb (data lost) or it is a warning and the conversion is done
> so no data lost ?
>
> Thanks for your insights
Date: Tue, 12 Oct 2010 09:13:07 -0700 (PDT)
Message-ID: <1bfb35ac-8bb4-4ffb-99b9-23e8a70fb01a_at_q28g2000prb.googlegroups.com>
On Oct 9, 4:14 am, "bob123" <nom..._at_nowhere.com> wrote:
> Hi,
>
> when we import with a character set different from the database
> we have the follwing error (from memory):
>
> import done in ...
> server server uses ...
> export client uses ...
> export server uses
> conversion ...
>
> Is it a real pb (data lost) or it is a warning and the conversion is done
> so no data lost ?
>
> Thanks for your insights
It depends. For example, if you have eight bit data in a seven bit character set - which can happen easily - you would lose the eighth bit. If you set things up to make Oracle think it is not converting, you would avoid such a problem.
As Mark almost said, we would need the character sets involved, the exact versions, the exact error messages, and the NLS settings of everything involved.
There are several Oracle docs that can help here, including the Utilities manual and Globalization guides, as well as MOS docs and some web sites. There is documentation on which character sets are sub or supersets, and a csscan utility that can help with determining if a problem would exist.
jg
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2010/oct/11/qualcomm-gets-snapdragon-in-new-windows-phones/Received on Tue Oct 12 2010 - 11:13:07 CDT