OraFAQ Forum: Server Utilities » Different Charsets from Export 8.1.7 and Import 9.2

Home » RDBMS Server » Server Utilities » Different Charsets from Export 8.1.7 and Import 9.2

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Different Charsets from Export 8.1.7 and Import 9.2 [message #72987]

Fri, 09 January 2004 04:24

Albernd
Messages: 2
Registered: January 2004

Junior Member

Hello,

I have a Problem with different Charsets like the Message below (The German special-caracters will be loose there dots).

Export-Datei wurde von EXPORT:V08.01.07 �ber konventionellen Pfad erstellt
Importvorgang mit Zeichensatz WE8ISO8859P1 und Zeichensatz AL16UTF16 NCHAR durchgef�hrt
Export-Client verwendet Zeichensatz US7ASCII (m�gliche Zeichensatzkonvertierung)
Export-Server verwendet Zeichensatz WE8ISO8859P1 NCHAR (m�gliche Zeichensatzkonvertierung)

There are 2 Solaris-Server (one with Oracle 8.1.7, the other with Oracle 9.2). I want to export from 8.1.7 and import to 9.2. The Datatransfer between the servers in via FTP binary-mode.
Will it work, when I change the Export-Client to Charset WE8ISO8859P1? If Yes - how can I change the Export-Client.

Report message to a moderator

Re: Different Charsets from Export 8.1.7 and Import 9.2 [message #72990 is a reply to message #72987]

Fri, 09 January 2004 06:38

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use the lower verson of oracle to do the export ( 817)
and use the same lower version of oracle to do the import into higher version( 9i).
else
if u want the othe way, u have to install the export views of 9i in 8i database.

do the export in 8i server.
do the import from 8i server to 9i server.
use tnsconnectstrings to talk to 9i database.
so u no need to do ftp transfers.
if u wanted to do ftp just make sure it is in binary mode. It will work.

Report message to a moderator

Re: Different Charsets from Export 8.1.7 and Import 9.2 [message #73052 is a reply to message #72990]

Fri, 23 January 2004 13:54

Albernd
Messages: 2
Registered: January 2004

Junior Member

Thank you for your help - it works.

Report message to a moderator

Re: Different Charsets from Export 8.1.7 and Import 9.2 [message #73081 is a reply to message #73052]

Fri, 30 January 2004 08:42

Navaneethakrishnan
Messages: 2
Registered: January 2004

Junior Member

I have a problem when i import the dump file in oracle 8i versons.it gives the error like that NCHAR set problem.NLS_language is AMERICAN_AMERICA.WE8IS08859P1.
WHAT CAN I DO?PLS solve it.

Report message to a moderator

Previous Topic:	Very urgent Multi master replication not working in 9i .
Next Topic:	how to stop SMON

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 07:37:44 CDT 2024