oracle exp&imp之IMP-00037: Character set marker unknown
最近,為地市技術人員做技術支援,碰到一個很奇怪的問題,別人給他提供一個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)
報錯資訊如下:
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Unknown initial character set index ‘255‘ received from server. Initial client character set can beIndexServerclient
- mysqlbinlog: unknown variable 'default-character-set=utf8'MySql
- 【轉】修改Oracle字符集(character set)Oracle
- Oracle 10中修改字符集(character set)Oracle
- MYSQL5.5修改字符集報錯:unknown variable 'default-character-set=utf8'MySql
- JMeter連線mysql資料庫之connector包匹配問題(Cannot create PoolableConnectionFactory (Unknown initial character set index...)JMeterMySql資料庫Index
- Indexing Mixed-Character Set ColumnsIndex
- character_set_database的意義Database
- 【Mysql】character-set-server引數MySqlServer
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- Variable 'character_set_client' can't be set to the value of Null的解決方法clientNull
- [mysql] 批量匯入提示: Variable ‘character_set_client’ can’t be set to the value of ‘NULLMySqlclientNull
- EXP&IMP PIPE
- mysql關於字符集character set的總結MySql
- rhel4 mysql5.5 字符集_character setMySql
- rhel5_oracle10g_10.2.0.4_字符集character set_nls_valid_valueOracle
- ORACLE RAC UNKNOWNOracle
- MySQL字符集和校對規則(character set & collation)MySql
- MySQL:簡單記錄character_set_server影響引數MySqlServer
- B19306_01 閱讀筆記(character set)筆記
- 關於MySQL中的8個 character_set 變數說明MySql變數
- Qt #pragma execution_character_set("utf-8") 執行字符集QT
- using escape character whitin oracleOracle
- 老外的EXP&IMP總結
- oracle 之 CLUSTER_INTERCONNECTS is not set to the recommended valueOracle
- oracle set eventsOracle
- oracle set roleOracle
- Redis之setRedis
- oracle全文索引之STOPLIST_ CTXCAT 索引_INDEX SETOracle索引Index
- Changing Primary DB Character Set without Recreate DG Physical Standby_1124165.1
- Oracle裡的setOracle
- 六、redis之setRedis
- JAVA類庫之——Character類(持續更新)Java
- configuring Csscan in 10g and 11g (Database Character Set Scanner)_745809.1CSSDatabase
- error MSB8031 Building an MFC project for a non-Unicode character set is deprecatedErrorUIProjectUnicode
- AL32UTF8 / UTF8 (Unicode) Database Character Set Implications [ID 788156.1]UnicodeDatabase
- Oracle set unused的用法Oracle
- Oracle SET 命令總結Oracle