oracle exp&imp之IMP-00037: Character set marker unknown

清風艾艾發表於2017-04-27
    最近,為地市技術人員做技術支援,碰到一個很奇怪的問題,別人給他提供一個exp的dmp檔案,他在本地進行imp的時候報錯:IMP-00037:Character set marker unknown
報錯資訊如下:
C:\Users\localadmin>imp test/oracle file=C:\Users\localadmin\Desktop\jzdjxx.dmp log=C:\Users\localadmin\Deskto
p\jzdjxx.log
Import: Release 11.2.0.1.0 - Production on 星期四 4月 27 11:34:16 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
連線到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
IMP-00037: 未知字符集標記
IMP-00000: 未成功終止匯入
C:\Users\localadmin>
經測試,不是expdp匯出的dmp檔案,測試資訊如下:
C:\Users\localadmin>impdp test/oracle directory=MYEXPDP dumpfile=jzdjxx.dmp logfile=jzdjxx.log
Import: Release 11.2.0.1.0 - Production on 星期四 4月 27 11:31:58 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
連線到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: 引數值無效
ORA-39000: 轉儲檔案說明錯誤
ORA-31619: 轉儲檔案 "c:\jzdjxx.dmp" 無效
在linux作業系統上,檢視該dmp檔案的字符集,提示資訊如下:
[root@docmaster ~]#  cat jzdjxx.dmp |od -x|head -1|awk '{print $2 $3}'|cut -c 3-6
5353
正確的字符集標識應該是
0354
資料庫中的字符集對照碼驗證:
SQL> select nls_charset_name(to_number('5353','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('5353','XXXX'
----------------------------------------
SQL> select nls_charset_name(to_number('0354','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('0354','XXXX'
----------------------------------------
ZHS16GBK
   查詢oracle官方metalink,提示exp的dmp檔案損壞:
OERR: IMP 37 "Character set marker unknown" (文件 ID 21669.1)
Error:  IMP 37
Text:   Character set marker unknown
-------------------------------------------------------------------------------
Cause:  The export file is corrupted.
Action: Try to obtain an uncorrupted version of the export file.
        If the export file is not corrupted, report this as an Import
        internal error and submit the export file to customer support.



來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29357786/viewspace-2138102/,如需轉載,請註明出處,否則將追究法律責任。

相關文章