Hi All,

Every time when i do import am getting the following warning :

Warning: the objects were exported by TBFBGL, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)

So inorder to solve this i have tried to set NLS_LANG in the following manner :
C:\set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

But the parameter value is not getting affected..So can you tell me a possible way.

Who is the "you" while performing the import? Which mode? What are the versions involved?

The client performing the export used a different character set than the server. Can the export be re-done?

http://download.oracle.com/docs/cd/B10501_...h10.htm#1009525

See note 227330.1 on MetaLink.

Hi Steve,

i have attached my log file so that it will be clear for you so please check it out.

why do you care - the two database have different character sets - does it actually matter?

Hi Dave,

well thanks for you are reply.Its not the question whether to matter or not but i just wanted to avoid that warning.

have the same character sets then

plus its not a warning, the only warning was about the objects not being exported by you

in windows for 10g database - you may change entry in registry located at

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_<oracle_home_name>

and change nls_lang prarmeter with

NLS_LANG= <language_territory.(same characterset used while exporting)>

to avoid possible char set conversion.

I have done what you have suggested.I changed in the registry and then restarted my system but its not affected in the database.So i verified whether its changed in the registry or not.It has the value which i entered.Then i restarted my database also.But unfortunately its not affected.

the databases have different character sets, nothing to do with registry settings

>> Warning: the objects were exported by TBFBGL, not by you

This is just an informational message, not a problem.