Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

oracle 9i  import a dmp file with another character set

Posted on 2009-12-30
4
Medium Priority
?
1,057 Views
Last Modified: 2013-12-19
i have installed an oracle 9i database with EL8MSWIN1253 character set. I am trying to import a dmp file from another pc  which uses a different character set. (export client is using
WE8ISO8859P1 character set and export server is using EL8ISO8859P7 NCHAR character set).

My problem is that i cant see the Greek characters correcty with Sqlplusw , Sqlplus worksheet or isqlplus). How can i fix this situation? Should i give some parameters in the imp utility or should i alter something in the registry?

You may see the attached file for more details

Happy new year to everyone !!!



Document.doc
0
Comment
Question by:basilhs_s
  • 2
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
raju1105 earned 1500 total points
ID: 26145039
Hi,

You will have to set NLS_LANG while doing export and also doing import.

Try using set NLS_LANG=AMERICAN_AMERICA.AL32UTF8 before you export & import.

Regards,
0
 

Author Comment

by:basilhs_s
ID: 26145316
is this enough? is it possible to lose the greek characters?
0
 
LVL 3

Expert Comment

by:raju1105
ID: 26151951
Hi,

Do you want to lose the Greek characters or want to import them exactly the same way it is in source database?

If you want to import the Greek chatacters you should keep NLS_LANG on both the source & target servers.
0
 

Author Closing Comment

by:basilhs_s
ID: 31671159
thanks vey much
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to recover a database from a user managed backup
Suggested Courses
Course of the Month10 days, 4 hours left to enroll

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question