OraFAQ Forum: Server Administration » Cyrillic in export from oracle7.3 and import in oracle9.1

Home » RDBMS Server » Server Administration » Cyrillic in export from oracle7.3 and import in oracle9.1

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

Cyrillic in export from oracle7.3 and import in oracle9.1 [message #232844]

Mon, 23 April 2007 10:04

chugunitz
Messages: 4
Registered: April 2007
Location: Kursk

Junior Member

Hi, greetings to all!
I maked one .dmp file with tool of oracle 7.1. When i try to import it in oracle9 with oracle9 import program, it suckseed, but all cyrillic is destroyed (converted into "?").
Can someone help me to solve this problem?

Thanks in advance.

Report message to a moderator

Re: Cyrillic in export from oracle7.3 and import in oracle9.1 [message #232848 is a reply to message #232844]

Mon, 23 April 2007 10:32

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is a problem with your character set.
Check:
- during export NLS_LANG is set to the same as source database
- during import NLS_LANG is set to the same as source or target database
- target database character set supports cyrillic characters.

Regards
Michel

Report message to a moderator

Re: Cyrillic in export from oracle7.3 and import in oracle9.1 [message #232923 is a reply to message #232848]

Tue, 24 April 2007 01:54

chugunitz
Messages: 4
Registered: April 2007
Location: Kursk

Junior Member

Thanck you very much. I'll check.

Report message to a moderator

Previous Topic:	migration from 8.0 to 9i
Next Topic:	CPUAPR07 patch

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:46:21 CDT 2024