Oracle数据导入导出

<p>
</p>
<p class="MsoNormal"><span>一、数据导出（</span><span lang="EN-US">exp.exe</span><span>）</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">1</span><span>、将数据库</span><span lang="EN-US">orcl</span><span>完全导出，用户名</span><span lang="EN-US">system</span><span>，密码</span><span lang="EN-US">accp</span><span>，导出到</span><span lang="EN-US">d:/daochu.dmp</span><span>文件中</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">exp system/accp@orcl file=d:/daochu.dmp full=y</span></p>
<p class="MsoNormal"><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">2</span><span>、将数据库</span><span lang="EN-US">orcl</span><span>中</span><span lang="EN-US">system</span><span>用户与</span><span lang="EN-US">sys</span><span>用户的表导出</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">exp system/accp@orcl file=d:/daochu.dmp <span></span>owner=(system,sys)</span></p>
<p class="MsoNormal"><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">3</span><span>、将数据库</span><span lang="EN-US">orcl</span><span>中的</span><span lang="EN-US">scott</span><span>用户的表</span><span lang="EN-US">emp</span><span>、</span><span lang="EN-US">dept</span><span>导出</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">exp scott/accp@orcl file= d:/daochu.dmp tables=(emp,dept)</span></p>
<p class="MsoNormal"><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">4</span><span>、将数据库</span><span lang="EN-US">orcl</span><span>中的表空间</span><span lang="EN-US">testSpace</span><span>导出</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US"><span> </span>exp system/accp@orcl file=d:/daochu.dmp
tablespaces=(testSpace)</span></p>
<p class="MsoNormal"><span lang="EN-US"></span></p>
<p class="MsoNormal"><span>二、数据导入（</span><span lang="EN-US">imp.exe</span><span>）</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">1</span><span>、将</span><span lang="EN-US">d:/daochu.dmp </span><span>中的数据导入</span><span> <span lang="EN-US">orcl</span></span><span>数据库中。</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US"><span> </span>imp system/accp@orcl file=d:/daochu.dmp
full=y</span></p>
<p class="MsoNormal"><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">2</span><span>、如果导入时，数据表已经存在，将报错，对该表不会进行导入。加上</span><span lang="EN-US">ignore=y</span><span>即可。</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US"><span> </span>imp scott/accp@orcl file=d:/daochu.dmp <span></span>full=y <span></span>ignore=y</span></p>
<p class="MsoNormal"><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">3</span><span>、将</span><span lang="EN-US">d:/daochu.dmp</span><span>中的表</span><span lang="EN-US">emp</span><span>导入</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">imp system/accp@orcl file=d:/daochu.dmp tables=(emp)</span></p>