Re: Export / Import

An idea

When you do your export, check your NLS_LANG, on UNIX do an echo $NLS_LANG and on NT check this variable in the registry. The NLS should be the same e.g AMERICAN_AMERICA.WE8ISO5589P1

Good luck

Maitee Alexandria <maitee_at_hospitalalianca.com.br> wrote in article <645346C45E37D211ACDC006097D1798C9A1ABD_at_news.telebahia.net.br>...
> We have two database servers. One back-up server running NT ( ORACLE 7.3
)
> and the other running HP - UNIX (ORACLE 8 ) in production.
>
> We have been able to import / export information from NT to UNIX using
> IMPORT/EXPORT UTILITIES bundled with ORACLE 7.3 for NT without any loss
of
> accentuation.
>
> The problem happens when we try doing the same using IMPORT/EXPORT
UTILITIES
> for ORACLE 8. Everytime we do an Import/Export from whichever server to
each
> other executing ORACLE 8 UTILITIES at the Unix server all the
accentuation
> in table contents is lost (i.e. '?' instead of 'Ç').
>
> The strangest is that when we export a correctly accentuated table from
> ORACLE 8 (i.e: customer ), drop the table from the database and then
> import it back from file .dmp, the accentuation is also lost.
>
> What´s the problem ? Is there a BUG for IMPORT / EXPORT for UNIX ?
>
> Obs.: The both databases have the same character set. ( WE8ISO5589P1 ).
>
>
>
>
>
>
>
Received on Wed Sep 16 1998 - 04:03:55 CDT