imp-00016 required character set conversion (type 1 to 850) not supported [message #70441] |
Fri, 14 June 2002 02:26 |
cmn
Messages: 19 Registered: March 2002
|
Junior Member |
|
|
Platform:redhat7.2(host1,host2)
oracle version:oracle8.1.7(db_1,db_2)
database db_1 on host1
database db_2 on host2
1.The value of props$ on db_1 is same as db_2.
2.When I export from db_1 via table mode then import db2,
no errors occured.
exp file=test.dmp tables=test user_id=username/password
imp file=test.dmp fromuser=user1 touser=user2
import successfully.
3.But when I export from db_2 via user mode level then import db_2,I encountered imp-00016.
exp file=test.dmp owner=user1 userid=username/password
imp file=test.dmp fromuser=user1 touser=user2 userid=username/password
imp-00016 : : required character set conversion (type 1 to 850) not supported.
Regards
|
|
|
|
|
Re: imp-00016 required character set conversion (type 1 to 850) not supported [message #70455 is a reply to message #70441] |
Sun, 16 June 2002 08:32 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
then,
this is a real cute issue!!
your error mesage is
imp-00016 : : required character set conversion (type 1 to 850) not supported
in case of windows,
NLS_LANG = LANGUAGE_TERRITORY.CHARACTERSET
where CHARACTERSET controls the character set used by the client application, normally
THAT MATCHES your Windows code page
C:>chcp
Active code page: 437
similarly the code page for
850 is WE8PC850
i am not very sure of redhat!( and i dont have one to simulate the error).
oracle says that,
There are three possible conversions when exporting and importing:
1) from the source database character set to the user session character set (based on setting for NLS_LANG during export)
2) from the export file character set to the user session character set based on the setting for NLS_LANG during import)
3) from the user session character set (criteria noted in #2) to the target database character set.
I think user session character set during import is not the same as the character set of the export file.
|
|
|