&nbsp; &nbsp; 前不久使用数据泵工具impdp进行数据导入时，遇到报错，提示无效的dunp文件，通过查询文档才知道是由于因为从高版本到低版本不兼容导致的，下面分享一下解决方法。<br /> <br /> <br /> <h1> 导入报错 </h1> <div> <div class="codeheads"> <p> 点击(<span style="cursor:pointer;color:red;" onclick="code_hide('code201')">此处</span>)折叠或打开 </p> </div> <div id="code201" class="codeText"> <ol style="margin:0 1px 0 0;padding:5px 0pt;" start="1" class="dp-css none_number"> <li> <span style="color:#000000;">C<span style="color:#0000CC;">:</span><span style="color:#0000CC;">\</span>Documents <span style="color:#0000FF;">and</span> Settings<span style="color:#0000CC;">\</span>hoegh<span style="color:#0000CC;">&gt;</span>impdp hoeghto<span style="color:#0000CC;">/</span>ilovehoegh <span style="color:#0000FF;">directory</span><span style="color:#0000CC;">=</span>data_pump_directory<br /> </span> </li> <li> dumpfile<span style="color:#0000CC;">=</span>20150826dynamic<span style="color:#0000CC;">.</span>dmp remap_schema<span style="color:#0000CC;">=</span> hoeghfrom<span style="color:#0000CC;">:</span>hoeghto remap_tablespace<span style="color:#0000CC;">=</span> hoeghfrom<span style="color:#0000CC;">:</span>hoeghto<br /> </li> <li> <br /> </li> <li> Import<span style="color:#0000CC;">:</span> <span style="color:#FF0000;">Release</span> 10<span style="color:#0000CC;">.</span>1<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0 <span style="color:#0000CC;">-</span> Production <span style="color:#0000FF;">on</span> 星期二<span style="color:#0000CC;">,</span> 01 9月<span style="color:#0000CC;">,</span> 2015 9<span style="color:#0000CC;">:</span>31<br /> </li> <li> <br /> </li> <li> Copyright <span style="color:#0000CC;">(</span>c<span style="color:#0000CC;">)</span> 2003<span style="color:#0000CC;">,</span> Oracle<span style="color:#0000CC;">.</span> <span style="color:#0000FF;">All</span> rights reserved<span style="color:#0000CC;">.</span><br /> </li> <li> <br /> </li> <li> Connected <span style="color:#0000FF;">to</span><span style="color:#0000CC;">:</span> Oracle <span style="color:#0000FF;">Database</span> 10g Enterprise Edition <span style="color:#FF0000;">Release</span> 10<span style="color:#0000CC;">.</span>1<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0 <span style="color:#0000CC;">-</span> Produc<br /> </li> <li> tion<br /> </li> <li> <span style="color:#0000FF;">With</span> the Partitioning<span style="color:#0000CC;">,</span> OLAP <span style="color:#0000FF;">and</span> <span style="color:#0000FF;">Data</span> Mining options<br /> </li> <li> <span style="background-color:#FFE500;">ORA</span><span style="color:#0000CC;background-color:#FFE500;">-</span><span style="background-color:#FFE500;">39001</span><span style="color:#0000CC;background-color:#FFE500;">:</span><span style="background-color:#FFE500;"> invalid argument </span><span style="color:#0000FF;background-color:#FFE500;">value</span><br /> </li> <li> <span style="background-color:#FFE500;">ORA</span><span style="color:#0000CC;background-color:#FFE500;">-</span><span style="background-color:#FFE500;">39000</span><span style="color:#0000CC;background-color:#FFE500;">:</span><span style="background-color:#FFE500;"> bad </span><span style="color:#FF0000;background-color:#FFE500;">dump</span> <span style="color:#0000FF;background-color:#FFE500;">file</span><span style="background-color:#FFE500;"> specification</span><br /> </li> <li> <span style="background-color:#FFE500;">ORA</span><span style="color:#0000CC;background-color:#FFE500;">-</span><span style="background-color:#FFE500;">31619</span><span style="color:#0000CC;background-color:#FFE500;">:</span><span style="background-color:#FFE500;"> invalid </span><span style="color:#FF0000;background-color:#FFE500;">dump</span> <span style="color:#0000FF;background-color:#FFE500;">file</span> <span style="color:#FF00FF;background-color:#FFE500;">"d:\data_pump_directory\20150826dynamic.dmp"</span><br /> </li> <li> <br /> </li> <li> <br /> </li> <li> <br /> </li> <li> C<span style="color:#0000CC;">:</span><span style="color:#0000CC;">\</span>Documents <span style="color:#0000FF;">and</span> Settings<span style="color:#0000CC;">\</span>hoegh<span style="color:#0000CC;">&gt;</span> </li> </ol> </div> </div> <h1> <span style="white-space:normal;"><br /> </span> </h1> <h1> <span style="white-space:normal;">源端数据库版本</span> </h1> <div style="white-space:normal;"> <div class="codeheads" style="width:1149.53125px;"> <p> 点击(<span onclick="code_hide('code119')" style="cursor:pointer;color:red;">此处</span>)折叠或打开 </p> </div> <div id="code119" class="codeText" style="width:1149.53125px;"> <ol start="1" class="dp-css none_number" style="margin-left:0px;padding:5px 0pt;"> <li> SQL<span style="color:#0000CC;">&gt;</span>&nbsp;<span style="color:#0000FF;">select</span>&nbsp;<span style="color:#0000CC;">*</span>&nbsp;<span style="color:#0000FF;">from</span>&nbsp;v$version<span style="color:#0000CC;">;</span><br /> </li> <li> <br /> </li> <li> BANNER<br /> </li> <li> <span style="color:#FF9900;">----------------------------------------------------------------</span><br /> </li> <li> Oracle&nbsp;<span style="color:#0000FF;">Database</span>&nbsp;10g Enterprise Edition&nbsp;<span style="color:#FF0000;background-color:#FFE500;">Release</span><span style="background-color:#FFE500;">&nbsp;10</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">2</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">0</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">4</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">0&nbsp;</span><span style="color:#0000CC;background-color:#FFE500;">-</span><span style="background-color:#FFE500;">&nbsp;64bi</span><br /> </li> <li> PL<span style="color:#0000CC;">/</span>SQL&nbsp;<span style="color:#FF0000;">Release</span>&nbsp;10<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>4<span style="color:#0000CC;">.</span>0&nbsp;<span style="color:#0000CC;">-</span>&nbsp;Production<br /> </li> <li> CORE 10<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>4<span style="color:#0000CC;">.</span>0 Production<br /> </li> <li> TNS&nbsp;<span style="color:#0000FF;">for</span>&nbsp;64<span style="color:#0000CC;">-</span>bit Windows<span style="color:#0000CC;">:</span>&nbsp;Version 10<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>4<span style="color:#0000CC;">.</span>0&nbsp;<span style="color:#0000CC;">-</span>&nbsp;Production<br /> </li> <li> NLSRTL Version 10<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>4<span style="color:#0000CC;">.</span>0&nbsp;<span style="color:#0000CC;">-</span>&nbsp;Production<br /> </li> <li> <br /> </li> <li> SQL<span style="color:#0000CC;">&gt;</span> </li> </ol> </div> </div> <br /> <br /> <h1> 目标端数据库版本 </h1> <div> <div class="codeheads"> <p> 点击(<span style="cursor:pointer;color:red;" onclick="code_hide('code258')">此处</span>)折叠或打开 </p> </div> <div id="code258" class="codeText"> <ol style="margin:0 1px 0 0;padding:5px 0pt;" start="1" class="dp-css none_number"> <li> <span style="color:#000000;">SQL<span style="color:#0000CC;">&gt;</span><br /> </span> </li> <li> SQL<span style="color:#0000CC;">&gt;</span> <span style="color:#0000FF;">select</span> <span style="color:#0000CC;">*</span> <span style="color:#0000FF;">from</span> v$version<span style="color:#0000CC;">;</span><br /> </li> <li> <br /> </li> <li> BANNER<br /> </li> <li> <span style="color:#FF9900;">----------------------------------------------------------------</span><br /> </li> <li> Oracle <span style="color:#0000FF;">Database</span> 10g Enterprise Edition <span style="color:#FF0000;background-color:#FFE500;">Release</span><span style="background-color:#FFE500;"> 10</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">1</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">0</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">2</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">0 </span><span style="color:#0000CC;background-color:#FFE500;">-</span><span style="background-color:#FFE500;"> Prod</span><br /> </li> <li> PL<span style="color:#0000CC;">/</span>SQL <span style="color:#FF0000;">Release</span> 10<span style="color:#0000CC;">.</span>1<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0 <span style="color:#0000CC;">-</span> Production<br /> </li> <li> CORE 10<span style="color:#0000CC;">.</span>1<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0 Production<br /> </li> <li> TNS <span style="color:#0000FF;">for</span> 32<span style="color:#0000CC;">-</span>bit Windows<span style="color:#0000CC;">:</span> Version 10<span style="color:#0000CC;">.</span>1<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0 <span style="color:#0000CC;">-</span> Production<br /> </li> <li> NLSRTL Version 10<span style="color:#0000CC;">.</span>1<span style="color:#0000CC;">.</span>0<span style="color:#0000CC;">.</span>2<span style="color:#0000CC;">.</span>0 <span style="color:#0000CC;">-</span> Production<br /> </li> <li> <br /> </li> <li> SQL<span style="color:#0000CC;">&gt;</span> </li> </ol> </div> </div> <br /> <h1> 添加version参数 </h1> &nbsp; &nbsp;&nbsp;源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0，源端数据库版本高于目标端数据库版本；<span style="white-space:normal;">解决的办法很简单，从</span>源端数据库导出数据时加上目标端version即可，参看一下sql语句：<br /> <div> <div class="codeheads"> <p> 点击(<span style="cursor:pointer;color:red;" onclick="code_hide('code700')">此处</span>)折叠或打开 </p> </div> <div id="code700" class="codeText"> <ol style="margin:0 1px 0 0;padding:5px 0pt;" start="1" class="dp-css none_number"> <li> <span style="color:#000000;">expdp hoeghfrom<span style="color:#0000CC;">/</span>ilovehoegh <span style="color:#0000FF;">directory</span><span style="color:#0000CC;">=</span>data_pump_directory dumpfile<span style="color:#0000CC;">=</span>20150826dynamic<span style="color:#0000CC;">.</span>dmp tables<span style="color:#0000CC;">=</span><span style="color:#0000CC;">(</span>HOEGH<span style="color:#0000CC;">)</span> <span style="background-color:#FFE500;">version</span><span style="color:#0000CC;background-color:#FFE500;">=</span><span style="background-color:#FFE500;">10</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">1</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">0</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">2</span><span style="color:#0000CC;background-color:#FFE500;">.</span><span style="background-color:#FFE500;">0</span></span> </li> </ol> </div> </div> &nbsp; &nbsp; 接下来，我们再次执行impdp语句就ok了。<br /> <br /> <div style="color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;text-indent:32px;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:16px;"><span style="font-size:x-small;"><strong>hoegh</strong></span></span> </div> <div style="color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;text-indent:32px;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:16px;"><span style="font-size:x-small;"><strong>15.9.15</strong></span></span> </div> <div style="color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;text-indent:32px;background-color:#FFFFFF;"> <span style="font-family:'Courier New';font-size:16px;"><span style="font-size:x-small;"><strong>-- The End --</strong></span></span> </div> <br /> <br />