Manpreet, here are what we have for the NSL parameters in both databases,

PARAMETER VALUE-local OREGON-client
-------------------- ----------- ---------
NLS_LANGUAGE AMERICAN AMERICAN
NLS_TERRITORY AMERICA AMERICA
NLS_CURRENCY $ DEFAULT
NLS_ISO_CURRENCY AMERICA DEFAULT
NLS_NUMERIC_CHARACTE ., DEFAULT
RS
NLS_DATE_FORMAT DD-MON-YY D EFAULT
NLS_DATE_LANGUAGE AMERICAN DEFAULT
NLS_CHARACTERSET US7ASCII DEFAULT
NLS_SORT BINARY DEFAULT
NLS_CALENDAR GREGORIAN NOT DEFINED

Some of the parameters are different, but Language, territory, and character set are the same. Do I need to reset the parameters that are different? How do I do that in import script, can you provide an example?

Jgmagnus, thanks for the advise, but we don't have IMPORT GUI 'Data Manager' installed. So command line is the only option that is available.

Mr.Hanky, the un-compress file does not have .dmp extension. How would this make the different, please explain? I have getting several dmp files without .dmp extention and they were imported fine. I am going to try to use uncompress dmp file for import, hope that solve the poblem.

Thanks for all you help!