oracle 9i  import a dmp file with another character set

Posted on 2009-12-30
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 !!!

Question by:basilhs_s
    LVL 3

    Accepted Solution


    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.


    Author Comment

    is this enough? is it possible to lose the greek characters?
    LVL 3

    Expert Comment


    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.

    Author Closing Comment

    thanks vey much

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now