exp/imp with different character set

I got the dump file that was exported using US7ASCII and my database is WE8ISO8859P1. what do I need to do to import this dump file into my database without having any problems???

thanks

No problem.

how do you do it ???

what do you need to do ???

Just do regular import and Oracle will automatically convert chars during import.

no it won't

Sometimes it will sometimes it won't. Depends on the charactersets - if the export is a subset of the characterset in the target database then the binaries will attempt to convert. Otherwise you will need to switch the characterset on the during the export.

For example:

I am assuming a Unix type machine. Under windows I think you will need to change a registry key or something but I am not sure.

1) change the environment variable of NLS_LANG to that of your target database:

echo $NLS_LANG
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859
echo $NLS_LANG
AMERICAN_AMERICA.WE8ISO8859P1

2) do your export. You should see something like this before the data starts to get exported:

Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set
server uses UTF8 character set (possible charset conversion)

3) now you should be able to import the dmp file into your target database.

Conversely you can do this on the import too. Change the NLS_LANG variable before importing and this should convert the dmp file but I personally think it's easier doing this on the export.

In Windows (dos really) you do:

set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

Then do the export.

HTH

I am aware of this but the question is what if I already had the dump file that was exported from the US7ASCIIn abd now how am I supposed to import it into the existing database

As you've allready been told by supower, you shouldn't have any difficulties - simply import it, that's it.

If you are not sattisfied with supower's answer, it would be nice of you and ashley75 if you provide us with some details, like OS, Oracle release, imp command you are using, error messages you are geting, etc ....

http://metalink.oracle.com/metalink/...1&p_showHelp=1

US7ASCII is a subset of WE8ISO8859P1 so the binaries will convert it on it's own.

http://metalink.oracle.com/metalink/...1&p_showHelp=1

Quote:

---

Originally posted by mike2000
I am aware of this but the question is what if I already had the dump file that was exported from the US7ASCIIn abd now how am I supposed to import it into the existing database

---

mike2000 or ashley75 do you peeps ever go to do some research yourselves by reading docs and webbing metalink? if you want to do some serious job you might as well start to do so

Quote:

---

Originally posted by pando
mike2000 or ashley75 do you peeps ever go to do some research yourselves by reading docs and webbing metalink? if you want to do some serious job you might as well start to do so

---

I cant be more agree with you pando, lazy people get what they deserve!