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.
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:
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 ....
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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