--1、导出schema(schema模式) DECLARE l_dp_handle NUMBER; l_last_job_state VARCHAR2 (30) := 'UNDEFINED'; l_job_state VARCHAR2 (30) := 'UNDEFINED'; l_sts KU$STATUS; BEGIN --sepcified operation,job mode l_dp_handle := DBMS_DATAPUMP.open (operation => 'EXPORT' , job_mode => 'SCHEMA' , remote_link => NULL , job_name => 'JOB_EXP1' , version => 'LATEST'); --specified dumpfile and dump directory DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'scott_schema.dmp' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_DUMP_FILE); --specified log file and dump directory DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'scott_schema.log' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_LOG_FILE); --specified fliter for schema DBMS_DATAPUMP. metadata_filter (handle => l_dp_handle , name => 'SCHEMA_EXPR' , VALUE => 'IN (''SCOTT'')'); DBMS_DATAPUMP.start_job (l_dp_handle); DBMS_DATAPUMP.detach (l_dp_handle); END; / --2、导出特定表table(表模式) DECLARE l_dp_handle NUMBER; l_last_job_state VARCHAR2 (30) := 'UNDEFINED'; l_job_state VARCHAR2 (30) := 'UNDEFINED'; l_sts KU$STATUS; BEGIN l_dp_handle := DBMS_DATAPUMP.open (operation => 'EXPORT' , job_mode => 'TABLE' , remote_link => NULL , job_name => 'JOB_EXP2' , version => 'LATEST'); DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'emp_tbl.dmp' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_DUMP_FILE); DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'emp_tbl.log' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_LOG_FILE); -->如果非当前帐户，使用下面的过滤条件，即特定schema下的特定表，如为当前帐户，此过滤条件可省略 DBMS_DATAPUMP. metadata_filter (handle => l_dp_handle , name => 'SCHEMA_EXPR' , VALUE => 'IN(''SCOTT'')'); DBMS_DATAPUMP. metadata_filter (handle => l_dp_handle , name => 'NAME_EXPR' , VALUE => 'IN(''EMP'')'); DBMS_DATAPUMP.start_job (l_dp_handle); DBMS_DATAPUMP.detach (l_dp_handle); END; / --3、导出schema并过滤掉特定表(使用非当前帐户导出时应过滤schema) DECLARE l_dp_handle NUMBER; BEGIN l_dp_handle := DBMS_DATAPUMP.open (operation => 'EXPORT', job_mode => 'SCHEMA'); DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'scott_filter.dmp' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_DUMP_FILE); DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'scott_filter.log' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_LOG_FILE); DBMS_DATAPUMP. metadata_filter (handle => l_dp_handle , name => 'SCHEMA_LIST' , VALUE => ' ''SCOTT'' '); DBMS_DATAPUMP.metadata_filter (handle => l_dp_handle , name => 'NAME_EXPR' , VALUE => ' !=''EMP'' ' , object_type => 'TABLE'); DBMS_DATAPUMP.start_job (l_dp_handle); END; / --4、导出当前schema下的所有表并过滤特定表 DECLARE l_dp_handle NUMBER; BEGIN l_dp_handle := DBMS_DATAPUMP.open (operation => 'EXPORT', job_mode => 'TABLE'); DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'scott_filter_2.dmp' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_DUMP_FILE); DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'scott_filter_2.log' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_LOG_FILE); DBMS_DATAPUMP.metadata_filter (handle => l_dp_handle , name => 'NAME_EXPR' , VALUE => ' !=''EMP'' '); DBMS_DATAPUMP.metadata_filter (handle => l_dp_handle , name => 'NAME_EXPR' , VALUE => ' !=''DEPT'' '); DBMS_DATAPUMP.start_job (l_dp_handle); DBMS_DATAPUMP.detach (l_dp_handle); END; / --5、批量过滤当前用户下的特定表 DECLARE l_dp_handle NUMBER; BEGIN l_dp_handle := DBMS_DATAPUMP.open (operation => 'EXPORT', job_mode => 'TABLE'); DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'scott_filter_3.dmp' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_DUMP_FILE); DBMS_DATAPUMP. add_file (handle => l_dp_handle , filename => 'scott_filter_3.log' , directory => 'DB_DUMP_DIR' , filetype => DBMS_DATAPUMP.KU$FILE_TYPE_LOG_FILE); DBMS_DATAPUMP.metadata_filter (handle => l_dp_handle , name => 'NAME_EXPR' , VALUE => ' NOT LIKE ''T%'' '); DBMS_DATAPUMP.start_job (l_dp_handle); DBMS_DATAPUMP.detach (l_dp_handle); END; / /**************************************************/ /* Author: Robinson Cheng */ /* Blog: http://blog.csdn.net/robinson_0612 */ /* MSN: robinson_0612@hotmail.com */ /* QQ: 645746311 */ /**************************************************/</td></tr> <p> </p></table> </div><!-- /content --> <div class="dede_pages"> <ul class="pagelist"> <li><a>共16页: </a></li><li><a href='20120118754_6.html'>上一页</a></li><li><a href='20120118754.html'>1</a></li><li><a href='20120118754_2.html'>2</a></li><li><a href='20120118754_3.html'>3</a></li><li><a href='20120118754_4.html'>4</a></li><li><a href='20120118754_5.html'>5</a></li><li><a href='20120118754_6.html'>6</a></li><li class="thisclass"><a href='#'>7</a></li><li><a href='20120118754_8.html'>8</a></li><li><a href='20120118754_9.html'>9</a></li><li><a href='20120118754_10.html'>10</a></li><li><a href='20120118754_11.html'>11</a></li><li><a href='20120118754_12.html'>12</a></li><li><a href='20120118754_13.html'>13</a></li><li><a href='20120118754_14.html'>14</a></li><li><a href='20120118754_15.html'>15</a></li><li><a href='20120118754_16.html'>16</a></li><li><a href='20120118754_8.html'>下一页</a></li> </ul> <p>本页地址 http://www.jybase.net/wangzhanbiancheng/20120118754.html</p> <p> <p> 【<a href="http://www.baidu.com/s?wd=使用 Oracle Datapump API 实现数据导出 .(7)" target="_blank"><font color=red>百度搜索更多</font></a>】 </p><p>【<a href="http://www.google.com.hk/search?q=使用 Oracle Datapump API 实现数据导出 .(7)" target="_blank"><font color=red>谷歌搜索更多</font></a>】</p> </div><!-- /pages --> <!-- //顶踩 --> <div class="newdigg" id="newdigg"> <div class="diggbox digg_good" onmousemove="this.style.backgroundPosition='left bottom';" onmouseout="this.style.backgroundPosition='left top';" onclick="javascript:postDigg('good',754)"> <div class="digg_act">顶一下</div> <div class="digg_num">(0)</div> <div class="digg_percent"> <div class="digg_percent_bar"><span style="width:0%"></span></div> <div class="digg_percent_num">0%</div> </div> </div> <div class="diggbox digg_bad" onmousemove="this.style.backgroundPosition='right bottom';" onmouseout="this.style.backgroundPosition='right top';" onclick="javascript:postDigg('bad',754)"> <div class="digg_act">踩一下</div> <div class="digg_num">(0)</div> <div class="digg_percent"> <div class="digg_percent_bar"><span style="width:0%"></span></div> <div class="digg_percent_num">0%</div> </div> </div> </div> <script language="javascript" type="text/javascript">getDigg(754);</script> <!-- //顶踩部份的源码结束 --> <div class="boxoff"> <strong>------分隔线----------------------------</strong> </div> <div class="handle"> <div class="context"> <ul> <li>上一篇：<a href='http://www.jybase.net/wangzhanbiancheng/20111113614.html'>js的字符串加密/javascript字符编码 escape,urlencode等</a> </li> <li>下一篇：<a href='http://www.jybase.net/wangzhanbiancheng/20120120756.html'>关于js中call和apply函数的应用</a> </li> </ul> </div><!-- /context --> <div class="actbox"> <ul> <li id="act-fav"><a href="http://www.jybase.net/plus/stow.php?aid=754" target="_blank">收藏</a></li> <li id="act-err"><a href="http://www.jybase.net/plus/erraddsave.php?aid=754&title=使用 Oracle Datapump API 实现数据导出 .(7)" target="_blank">挑错</a></li> <li id="act-pus"><a href="http://www.jybase.net/plus/recommend.php?aid=754" target="_blank">推荐</a></li> <li id="act-pnt"><a href="#" onClick="window.print();">打印</a></li> </ul> </div><!-- /actbox --> </div><!-- /handle --> </div><!-- /viewbox --> <!-- Baidu Button BEGIN --> <div id="bdshare" class="bdshare_t bds_tools get-codes-bdshare"> <a class="bds_qzone">QQ空间</a> <a class="bds_tsina">新浪微博</a> <a class="bds_tqq">腾讯微博</a> <a class="bds_renren">人人网</a> <span class="bds_more">更多</span> </div> <!-- //AJAX评论区 --> <!-- //主模板必须要引入http://www.jybase.net/include/dedeajax2.js --> <a name='postform'></a> <div class="mt1"> <dl> <dd> <div class="dede_comment_post"> <form action="#" method="post" name="feedback"> <input type="hidden" name="dopost" value="send" /> <input type="hidden" name="comtype" value="comments"> <input type="hidden" name="aid" value="754" /> <input type="hidden" name="fid" id='feedbackfid' value="0"/> <a name='postform'></a> <div class='leftinput'> <div class="icon_ctn"> <div class="dcmp-stand"> <strong>评价:</strong> <input type="radio" name="feedbacktype" checked="1" value="feedback" id="dcmp-stand-neu" /><label for="dcmp-stand-neu">中立</label> <input type="radio" name="feedbacktype" value="good" id="dcmp-stand-good" /><label for="dcmp-stand-good">好评</label> <input type="radio" name="feedbacktype" value="bad" id="dcmp-stand-bad" /><label for="dcmp-stand-bad">差评</label> </div><!-- /dcmp-stand --> <div class="icon_ctn" > 昵称: <input name="username" type="text" id="name" value="" onfocus="javascript:if(this.value=='') this.value='';" /> 验证码:<input type='text' name='validate' size='4' class='ipt-txt' /><img src="/include/vdimgck.php" id="validateimg" style="cursor:pointer" onclick="this.src=this.src+'?'" title="点击我更换图片" alt="点击我更换图片" /> <input type="hidden" type="checkbox" name="notuser" id="dcmp-submit-guest" /><label for="dcmp-submit-guest" /><!–匿名? –></label> </div> </div><!-- /dcmp-title --> <div class="dcmp-content"> <textarea cols="60" name="msg" rows="5" class="text_area" id="textarea">

• 电脑相关
• 语言编程
• 美工图像
• 网站建设
• 网络赚钱

• windows
• 各类编程
• linux
• qq相关
• 软件破解
• 系统安全

• 建站技巧|seo
• 在线工具
• 网页特效
• 网站编程
• 美工设计
• 网站安全

• 系统教程
• 编程教程
• 建站教程
• 美工教程
• 破解教程
• 网络安全教程

• 海量网赚项目
• 网赚教程
• seo|竞价|营销

• 系统软件下载
• 网络软件下载
• 电子书籍