Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Export / Import

Re: Export / Import

From: Jean-Philippe Squelbut <squelbut_at_csi.com>
Date: Fri, 11 Sep 1998 10:21:40 +0200
Message-ID: <ubsHa2V39GA.201@ntdwwaaw.compuserve.com>


Quick answer.
Perhaps it may help.
Have look at National Language Support variables. Client NLS variables on your PC or your .profile on Unix may explain this. Maitee Alexandria a écrit dans le message <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 Fri Sep 11 1998 - 03:21:40 CDT

Original text of this message

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