basilhs_s
asked on
oracle 9i import a dmp file with another character set
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
thanks vey much
ASKER