Help - Search - Members - Calendar
Full Version: IMPORT WARNING
Oracle DBA Forums > Oracle > Oracle Forum
Anupama Vadlapudi
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.
SteveC
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.
Anupama Vadlapudi
Hi Steve,

i have attached my log file so that it will be clear for you so please check it out.
dave
why do you care - the two database have different character sets - does it actually matter?
Anupama Vadlapudi
QUOTE (dave @ Jul 22 2008, 08:31 AM) *
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.
dave
have the same character sets then

plus its not a warning, the only warning was about the objects not being exported by you
Asad
QUOTE (Anupama Vadlapudi @ Jul 22 2008, 06:36 AM) *
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.


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.
Anupama Vadlapudi
QUOTE (Asad @ Jul 22 2008, 02:23 PM) *
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.
dave
the databases have different character sets, nothing to do with registry settings
burleson
>> Warning: the objects were exported by TBFBGL, not by you

This is just an informational message, not a problem.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.