Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to import a dump and I get the following message:

  Export file created by EXPORT:V10.02.01 via conventional path
  import done in US7ASCII character set and AL16UTF16 NCHAR character set
  import server uses WE8MSWIN1252 character set (possible charset conversion)
  export client uses EL8ISO8859P7 character set (possible charset conversion)

Is it possible to change NLS and how? Do I have to install Oracle XE from scratch?

share|improve this question
up vote 3 down vote accepted

There are two versions of XE, one for 'western' and one for 'universal'. Looks like you have the former, and I don't have the former to test with.

If you need to use multi-byte characters, you need the latter, but I think this issue should be okay.

US7ASCII is the lowest of the low (only uses character 1-127). WE8MSWIN1252 can use a 255 character set, as can EL8ISO8859P7. They are just a bit different.

Before doing the import, try


(or the windows equivalent).

share|improve this answer
Thanks a lot! I found that in the meanwhile and I wanted to add it here for others to benefit, but you beat me to it :-) – Petros Oct 22 '10 at 11:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.