oracle8.1.7数据库恢复出现错误，请问该怎么解决？（在线等)

sysroger 2003-10-20 09:40:09

电脑1(oracle8.1.7)用exp做了backup文件1018.dmp，现在想在电脑2(8.1.7)上用imp恢复(restore),出现下面错误提示：

IMP-00016: required character set conversion (type 31 to 852)not supported
IMP-00000: Import terminated unsuccessfully
请问该怎么解决？谢谢大家

...全文

61 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

daydayupliq 2003-10-20

打赏
举报

cmd>
set nls_lang=simplified chinese_china.zhs16cgb231280
或者
set nls_lang=american_america.zhs16cgb231280
再执行imp!!

sysroger 2003-10-20

打赏
举报

thank you a million, that'ok!

moswj 2003-10-20

打赏
举报

【转】下面是英文的解释，你看看合适你用不？
IMP-00016: required character set conversion (type num to num) not supported

Cause: Import could not convert the character format of the export file into the native character format.

Action: Change the user character set by setting the NLS_LANG environment variable to match the character set of the export file.

IMP-00000: import terminated unsuccessfully
Cause: Import encountered an Oracle error.

Action: Look up the accompanying Oracle message in the ORA message chapters of this manual, and take appropriate action.