【故障处理】IMP-00010错误 12C的dmp文件导入11G

D:\Users\xiaomaimiao>imp 'sys/lhr@192.168.59.129/oratest as sysdba' full=y file="E:\ash_20161108.dmp\ash_20161108.dmp"

Import: Release 11.2.0.1.0 - Production on Wed Nov 9 11:26:05 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

IMP-00010: not a valid export file, header failed verification

IMP-00000: Import terminated unsuccessfully

D:\Users\xiaomaimiao>imp 'sys/lhr@192.168.59.129/oratest as sysdba' full=y file="E:\ash_20161108.dmp\ash_20161108_01.dmp"

Import: Release 11.2.0.1.0 - Production on Wed Nov 9 11:28:24 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set

export client uses US7ASCII character set (possible charset conversion)

. importing SYS's objects into SYS

. importing SYS's objects into SYS

. . importing table                 "ASH_20161108"      29394 rows imported

Import terminated successfully without warnings.

[ZFZHLHRDB1:oracle]:/tmp>strings exp_ddl_lhr_02.dmp | head -10

TEXPORT:V11.02.00  ====》版本号 

DSYS    ====》使用SYS用户导出

RTABLES ====》基于表模式导出，RUSERS表示基于用户模式,RENTIRE表示基于全库模式

4096

Tue Aug 2 16:8:8 2016/tmp/exp_ddl_lhr_02.dmp====》生成的时间和文件地址

#C#G

#C#G

+00:00

BYTE

UNUSED

[ZFZHLHRDB1:oracle]:/tmp>strings  exp_ddl_lhr_02.dmp | grep "CREATE TABLE"|awk '{print $3}'|sed 's/"//g'

EMP ====》说明exp_ddl_lhr_02.dmp中只有一个emp表

[ZFZHLHRDB1:oracle]:/tmp>strings  exp_ddl_lhr_03.dmp | grep "CREATE TABLE"|awk '{print <span tabindex="0" class="MathJax" id="MathJax-Element-1-Frame" role="presentation" style="display:inline-block;position:relative;" data-mathml="3}'|sed&#xA0;'s/&quot;//g'|awk&#xA0;'{&#xA0;if&#xA0;(FNR==1)&#xA0;print&#xA0;&quot;tables=&quot;3}'|sed 's/"//g'|awk '{ if (FNR==1) print "tables="3}'|sed 's/"//g'|awk '{ if (FNR==1) print "tables=" 1 ; else print ","$1 }'

tables=DEF$_AQCALL

,DEF$_AQERROR

,DEF$_CALLDEST

,DEF$_DEFAULTDEST

,DEF$_DESTINATION

,DEF$_ERROR

,DEF$_LOB

,DEF$_ORIGIN

,DEF$_PROPAGATOR

,DEF$_PUSHED_TRANSACTIONS

,MVIEW$_ADV_INDEX

[ZFZHLHRDB1:oracle]:/tmp>

[ZFZHLHRDB1:oracle]:/oracle>ORACLE_SID=lhrdb

[ZFZHLHRDB1:oracle]:/oracle>exp  \'/ AS SYSDBA\'  tables=scott.emp  file=/tmp/exp_ddl_lhr_03.dmp  log=/tmp/exp_table.log  buffer=41943040 rows=n compress=n

Export: Release 11.2.0.4.0 - Production on Tue Oct 25 17:14:49 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Tes

Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set<<<<--当前环境下NLS_LANG的设置

server uses ZHS16GBK character set (possible charset conversion)<<<<--当前数据库的字符集

Note: table data (rows) will not be exported

About to export specified tables via Conventional Path ...

Current user changed to SCOTT

. . exporting table                            EMP

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.

[ZFZHLHRDB1:oracle]:/oracle>ORACLE_SID=mydb

[ZFZHLHRDB1:oracle]:/oracle>export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

[ZFZHLHRDB1:oracle]:/oracle>imp  \'/ AS SYSDBA\'  tables=xxx.xx  file=/tmp/exp_ddl_lhr_03.dmp

Import: Release 11.2.0.4.0 - Production on Tue Oct 25 17:21:02 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Tes

Export file created by EXPORT:V11.02.00 via conventional path

import done in ZHS16GBK character set and AL16UTF16 NCHAR character set<<<<--当前环境的NLS_LANG

import server uses WE8ISO8859P1 character set (possible charset conversion)<<<<--当前数据库的字符集

export client uses AL32UTF8 character set (possible charset conversion)<<<<--当前dmp文件的字符集

IMP-00029: cannot qualify table name by owner (xxx.xx), use FROMUSER parameter

IMP-00000: Import terminated unsuccessfully

SYS@lhrdb> SELECT NLS_CHARSET_NAME(TO_NUMBER('0354','XXXX')) FROM DUAL;

NLS_CHARSET_NAME(TO_NUMBER('0354','XXXX'

----------------------------------------

ZHS16GBK

cat /tmp/exp_ddl_lhr_02.dmp |od -x|head -1|awk '{print <span tabindex="0" class="MathJax" id="MathJax-Element-2-Frame" role="presentation" style="display:inline-block;position:relative;" data-mathml="22 2 3}'|cut -c 3-6

[ZFZHLHRDB1:oracle]:/oracle>cat /tmp/exp_ddl_lhr_02.dmp |od -x|head -1|awk '{print <span tabindex="0" class="MathJax" id="MathJax-Element-3-Frame" role="presentation" style="display:inline-block;position:relative;" data-mathml="22 2 3}'|cut -c 3-6

0354

...............................................................................................................................

● 本文作者：小麦苗，只专注于数据库的技术，更注重技术的运用

● 本文在itpub（http://blog.itpub.net/26736162）、博客园(http://www.cnblogs.com/lhrbest)和个人微信公众号（xiaomaimiaolhr）上有同步更新

● 本文itpub地址：http://blog.itpub.net/26736162/viewspace-2128197/

● 本文博客园地址：http://www.cnblogs.com/lhrbest/p/6048307.html

● 本文pdf版及小麦苗云盘地址：http://blog.itpub.net/26736162/viewspace-1624453/

● QQ群：230161599     微信群：私聊

● 联系我请加QQ好友(642808185)，注明添加缘由

● 于 2016-11-09 19:00 ~ 2016-11-09 22:00 在中行完成

● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解

● 版权所有，欢迎分享本文，转载请保留出处

...............................................................................................................................

手机长按下图识别二维码或微信客户端扫描下边的二维码来关注小麦苗的微信公众号：xiaomaimiaolhr,免费学习最实用的数据库技术。