Home » RDBMS Server » Server Administration » Export-Import
Export-Import [message #56843] Wed, 30 April 2003 04:05 Go to next message
Dik
Messages: 27
Registered: June 2002
Junior Member
Hi,
I have export done in EE8ISO859P2 character set and, EE8ISO859P2 NCHAR character set on Unix. I would like to do import in Windows NT, do I need the same character set for import or can I use EE8MSWIN1250?

Report message to a moderator

Re: Export-Import [message #56845 is a reply to message #56843] Wed, 30 April 2003 05:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
set your NLS_LANG before export.
do the export
do the import

Report message to a moderator

Re: Export-Import [message #56876 is a reply to message #56843] Fri, 02 May 2003 00:42 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Yes. You have to setup the NLS_LANG=language_territory.EE8ISO859P2 before the import. The character set has to be the same as the exported db one. Then the imp process will do the conversion internaly.

For example:

c:>set oracle_sid=...
c:>set NLS_LANG=<language>_<territory>.EE8ISO859P2

c:> imp parfile=.....

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Verification test failure.
Next Topic: Drive Oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 30 15:13:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.