{"id":314,"date":"2021-08-01T17:51:26","date_gmt":"2021-08-01T09:51:26","guid":{"rendered":"http:\/\/dba.qishuo.xin\/?p=314"},"modified":"2022-04-23T22:04:13","modified_gmt":"2022-04-23T14:04:13","slug":"oracle%e7%9b%91%e6%8e%a7impdp-expdp%e7%9a%84%e8%bf%9b%e5%ba%a6%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"http:\/\/dba.qishuo.xin\/?p=314","title":{"rendered":"Oracle\u76d1\u63a7impdp\/expdp\u7684\u8fdb\u5ea6\u65b9\u6cd5"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<label for=\"ez-toc-cssicon-toggle-item-69f30ef12a158\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69f30ef12a158\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/dba.qishuo.xin\/?p=314\/#1_%E9%80%9A%E8%BF%87%E8%A7%86%E5%9B%BE\" >1. \u901a\u8fc7\u89c6\u56fe<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/dba.qishuo.xin\/?p=314\/#11_DBA_DATAPUMP_JOBS_%E8%A7%86%E5%9B%BE\" >1.1. DBA_DATAPUMP_JOBS \u89c6\u56fe<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/dba.qishuo.xin\/?p=314\/#12_DBA_DATAPUMP_SESSIONS_%E8%A7%86%E5%9B%BE\" >1.2. DBA_DATAPUMP_SESSIONS \u89c6\u56fe<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/dba.qishuo.xin\/?p=314\/#13_GVSESSION_LONGOPS_%E8%A7%86%E5%9B%BE\" >1.3. (G)V$SESSION_LONGOPS \u89c6\u56fe<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/dba.qishuo.xin\/?p=314\/#2_%E9%80%9A%E8%BF%87impdp%E5%91%BD%E4%BB%A4%E7%9A%84%E5%8F%82%E6%95%B0ATTACH\" >2. \u901a\u8fc7impdp\u547d\u4ee4\u7684\u53c2\u6570ATTACH<\/a><\/li><\/ul><\/nav><\/div>\n<p>\u5f53\u6570\u636e\u5e93\u6267\u884c<code>expdp\/impdp<\/code>\u547d\u4ee4\u7684\u65f6\u5019\uff0c\u5982\u679c\u6570\u636e\u91cf\u6bd4\u8f83\u5927\uff0c\u4e2d\u9014\u6709\u4e9b\u4eba\u4f1a\u7740\u6025\uff0c\u4e0d\u514d\u60f3\u770b\u770b\u8fdb\u5ea6\u5982\u4f55\uff0c\u6216\u8005\u67e5\u770b\u4ed6\u6b63\u5728\u6267\u884c\u7684\u4e8b\u52a1\u5185\u5bb9\u3002<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_%E9%80%9A%E8%BF%87%E8%A7%86%E5%9B%BE\"><\/span>1. \u901a\u8fc7\u89c6\u56fe<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u8fd9\u65f6\u53ef\u4ee5\u901a\u8fc7 \u89c6\u56fe\uff1a<code>DBA_DATAPUMP_JOBS\u3001DBA_DATAPUMP_SESSIONS\u3001\uff08G\uff09V$SESSION_LONGOPS<\/code>\u6765\u67e5\u770b\u3002<\/p>\n<h4><span class=\"ez-toc-section\" id=\"11_DBA_DATAPUMP_JOBS_%E8%A7%86%E5%9B%BE\"><\/span>1.1. <code>DBA_DATAPUMP_JOBS<\/code> \u89c6\u56fe<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u901a\u8fc7<code>dba_datapump_jobs<\/code>\u89c6\u56fe\u53ef\u4ee5\u67e5\u770b\u6b63\u5728\u6267\u884c\u6216\u672a\u6267\u884c\u7684Datapump \u4f5c\u4e1a\u3002<\/p>\n<pre><code class=\"language-sql\">SELECT *\n  FROM dba_datapump_jobs ddj\n WHERE ddj.state = &#039;EXECUTING&#039;;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_97c0948e8ad97eefaec67d14d9a5342e.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_97c0948e8ad97eefaec67d14d9a5342e.jpg\" alt=\"\" \/><\/a><\/p>\n<p>\u5b57\u6bb5\u89e3\u91ca\u5982\u4e0b\uff1a<\/p>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\">\u5b57\u6bb5\u540d\u79f0<\/th>\n<th style=\"text-align: left;\">\u5b57\u6bb5\u63cf\u8ff0<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\">OWNER_NAME<\/td>\n<td style=\"text-align: left;\">User that initiated the job<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">JOB_NAME<\/td>\n<td style=\"text-align: left;\">Job name<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">OPERATION<\/td>\n<td style=\"text-align: left;\">Type of operation being performed<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">JOB_MODE<\/td>\n<td style=\"text-align: left;\">Mode of operation being performed<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">STATE<\/td>\n<td style=\"text-align: left;\">Current job state<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">DEGREE<\/td>\n<td style=\"text-align: left;\">Number of worker proceses performing the operation<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">ATTACHED_SESSIONS<\/td>\n<td style=\"text-align: left;\">Number of sessions attached to the job<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">DATAPUMP_SESSIONS<\/td>\n<td style=\"text-align: left;\">Number of Datapump sessions participating in the job<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><span class=\"ez-toc-section\" id=\"12_DBA_DATAPUMP_SESSIONS_%E8%A7%86%E5%9B%BE\"><\/span>1.2. <code>DBA_DATAPUMP_SESSIONS<\/code> \u89c6\u56fe<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u901a\u8fc7<code>dba_datapump_sessions<\/code>\u89c6\u56fe\u53ef\u4ee5\u67e5\u8be2\u5230\u9644\u52a0\u5230\u4f5c\u4e1a\u7684datapump\u4f1a\u8bdd<\/p>\n<pre><code class=\"language-sql\">SELECT * FROM DBA_DATAPUMP_SESSIONS;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_2e1be8ae6168ba1108f695d964666a78.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_2e1be8ae6168ba1108f695d964666a78.jpg\" alt=\"\" \/><\/a><\/p>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\">\u5b57\u6bb5\u540d\u79f0<\/th>\n<th style=\"text-align: left;\">\u5b57\u6bb5\u63cf\u8ff0<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\">OWNER_NAME<\/td>\n<td style=\"text-align: left;\">User that initiated the job<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">JOB_NAME<\/td>\n<td style=\"text-align: left;\">Job name<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">INST_ID<\/td>\n<td style=\"text-align: left;\">Instance ID<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SADDR<\/td>\n<td style=\"text-align: left;\">Address of session attached to job \u901a\u8fc7INST_ID\u3001 SADDR\u8fd9\u4e24\u9879\u5c31\u80fd\u67e5\u627e\u5230\u6267\u884cdatapump\u4efb\u52a1\u7684\u4f1a\u8bdd\u4fe1\u606f\u3002<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SESSION_TYPE<\/td>\n<td style=\"text-align: left;\">Datapump session type<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><span class=\"ez-toc-section\" id=\"13_GVSESSION_LONGOPS_%E8%A7%86%E5%9B%BE\"><\/span>1.3. <code>(G)V$SESSION_LONGOPS<\/code> \u89c6\u56fe<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u8be5\u89c6\u56fe\u8bb0\u5f55\u4e86\u6267\u884c\u65f6\u95f4\u957f\u4e8e6\u79d2\u7684\u67d0\u4e2a\u64cd\u4f5c(\u8fd9\u4e9b\u64cd\u4f5c\u53ef\u80fd\u662f\u5907\u4efd\uff0c\u6062\u590d\uff0c\u6536\u96c6\u7edf\u8ba1\u4fe1\u606f\uff0cHash Join,Sort ,Nested loop\uff0cTable Scan, Index Scan \u7b49\u7b49)\uff0c\u8fd9\u4e2a\u89c6\u56fe\u901a\u5e38\u7528\u6765\u5206\u6790SQL\u8fd0\u884c\u7f13\u6162\u7684\u539f\u56e0\uff0c\u914d\u5408<code>V$SESSION<\/code>\u89c6\u56fe\u3002\uff08\u5982\u679c\u662f\u5728RAC,\u6539\u6210<code>GV$SESSION_LONGOPS<\/code>\u8fd9\u4e2a\u89c6\u56fe\uff09<\/p>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL TARGET FOR A20\nCOL USERNAME FOR A10\nCOL OPNAME FOR A20\n\nSELECT gvsl.INST_ID,\n       gvsl.SID,\n       gvsl.SERIAL#,\n       gvsl.OPNAME,\n       gvsl.CONTEXT,\n       gvsl.SOFAR,\n       gvsl.TOTALWORK,\n       ROUND(gvsl.SOFAR \/ gvsl.TOTALWORK * 100, 2) &quot;%_COMPLETE&quot;,\n       gvsl.start_time,\n       gvsl.time_remaining,\n       gvsl.elapsed_seconds,\n       gvsl.con_id,\n       gvsl.username,\n       gvsl.target\n  FROM GV$SESSION_LONGOPS gvsl\n WHERE OPNAME NOT LIKE &#039;%aggregate%&#039;\n   AND TOTALWORK != 0\n   AND SOFAR &lt;&gt; TOTALWORK\n ORDER BY &quot;%_COMPLETE&quot; DESC;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_8bd76d54f8c7e5251e8948a7f7916f09.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_8bd76d54f8c7e5251e8948a7f7916f09.jpg\" alt=\"\" \/><\/a><\/p>\n<table>\n<thead>\n<tr>\n<th style=\"text-align: left;\">\u5b57\u6bb5\u540d\u79f0<\/th>\n<th style=\"text-align: left;\">\u5b57\u6bb5\u63cf\u8ff0<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"text-align: left;\">SID<\/td>\n<td style=\"text-align: left;\">Session\u6807\u8bc6<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SERIAL#<\/td>\n<td style=\"text-align: left;\">Session\u4e32\u53f7<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">OPNAME<\/td>\n<td style=\"text-align: left;\">\u64cd\u4f5c\u7b80\u8981\u8bf4\u660e<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">TARGET<\/td>\n<td style=\"text-align: left;\">\u64cd\u4f5c\u8fd0\u884c\u6240\u5728\u7684\u5bf9\u8c61<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">TARGET_DESC<\/td>\n<td style=\"text-align: left;\">\u76ee\u6807\u5bf9\u8c61\u8bf4\u660e<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SOFAR<\/td>\n<td style=\"text-align: left;\">\u81f3\u4eca\u4e3a\u6b62\u5b8c\u6210\u7684\u5de5\u4f5c\u91cf<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">TOTALWORK<\/td>\n<td style=\"text-align: left;\">\u603b\u5de5\u4f5c\u91cf<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">UNITS<\/td>\n<td style=\"text-align: left;\">\u5de5\u4f5c\u91cf\u5355\u4f4d<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">START_TIME<\/td>\n<td style=\"text-align: left;\">\u64cd\u4f5c\u5f00\u59cb\u65f6\u95f4<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">LAST_UPDATE_TIME<\/td>\n<td style=\"text-align: left;\">\u7edf\u8ba1\u9879\u6700\u540e\u66f4\u65b0\u65f6\u95f4<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">TIMESTAMP<\/td>\n<td style=\"text-align: left;\">\u64cd\u4f5c\u7684\u65f6\u95f4\u6233<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">TIME_REMAINING<\/td>\n<td style=\"text-align: left;\">\u9884\u8ba1\u5b8c\u6210\u64cd\u4f5c\u7684\u5269\u4f59\u65f6\u95f4(\u79d2)<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">ELAPSED_SECONDS<\/td>\n<td style=\"text-align: left;\">\u4ece\u64cd\u4f5c\u5f00\u59cb\u603b\u82b1\u8d39\u65f6\u95f4(\u79d2)<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">CONTEXT<\/td>\n<td style=\"text-align: left;\">\u524d\u540e\u5173\u7cfb<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">MESSAGE<\/td>\n<td style=\"text-align: left;\">\u7edf\u8ba1\u9879\u7684\u5b8c\u6574\u63cf\u8ff0<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">USERNAME<\/td>\n<td style=\"text-align: left;\">\u6267\u884c\u64cd\u4f5c\u7684\u7528\u6237ID<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SQL_ADDRESS<\/td>\n<td style=\"text-align: left;\">\u5173\u8054v$sql<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SQL_HASH_VALUE<\/td>\n<td style=\"text-align: left;\">\u5173\u8054v$sql<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SQL_ID<\/td>\n<td style=\"text-align: left;\">\u5173\u8054v$sql<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">QCSID<\/td>\n<td style=\"text-align: left;\">\u4e3b\u8981\u662f\u5e76\u884c\u67e5\u8be2\u4e00\u8d77\u4f7f\u7528<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<pre><code class=\"language-sql\">SELECT *\n   FROM v$session a,v$session_longops b\n  WHERE a.SID = b.SID\n    AND a.SERIAL# = b.SERIAL# ;\n\nSELECT *\n  FROM v$sql a,v$session_longops b\n WHERE a.SQL_ID = b.SQL_ID ;\n\nSELECT *\n  FROM v$sqlarea a,v$session_longops b\n WHERE a.HASH_VALUE = b.SQL_HASH_VALUE;<\/code><\/pre>\n<p>\u5982\u679c\u662f\u5728RAC,\u6539\u6210<code>GV$SESSION_LONGOPS<\/code>\u8fd9\u4e2a\u89c6\u56fe\uff0c<code>\u6ce8\u610f\uff1aimpdp\u53ea\u80fd\u5728\u4e00\u4e2a\u5b9e\u4f8b\u4e0a\u8fd8\u539f<\/code>\u3002<br \/>\n\u4f8b\u5982\uff1a<\/p>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL OPNAME FOR A20\nCOL TARGET FOR A20\nCOL UNITS FOR A12\nCOL MESSAGE FOR A60\nCOL SQL_TEXT FOR A160\n\nSELECT b.start_time,\n       b.sid,\n       b.opname,\n       b.target,\n       b.sofar,\n       b.totalwork,\n       b.units,\n       b.elapsed_seconds,\n       b.sql_hash_value,\n       b.message,\n       a.sql_text\n  FROM gv$sqlarea a, gv$session_longops b\n WHERE a.hash_value = b.sql_hash_value\n   AND b.sofar != totalwork\n --AND b.target like &amp;target\n ORDER BY b.start_time DESC;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_49cb1a27541f5af0394c2b9b63b65319.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_49cb1a27541f5af0394c2b9b63b65319.jpg\" alt=\"\" \/><\/a><\/p>\n<pre><code class=\"language-sql\">SET LINES 300 PAGES 999\nCOL JOB_NAME FOR A20\nCOL STATE FOR A15\nCOL JOB_MODE FOR A10\nCOL OWNER_NAME FOR A12\nCOL MODULE FOR A10\nCOL MESSAGE FOR A120\nCOL SQL_TEXT FOR A160\n\nSELECT x.job_name,\n       b.state,\n       b.job_mode,\n       b.degree,\n       x.owner_name,\n       p.totalwork,\n       p.sofar,\n       round((p.sofar \/ p.totalwork) * 100, 2) done,\n       p.time_remaining,\n       y.module,\n       p.message,\n       z.sql_text\n  FROM dba_datapump_jobs b\n  LEFT JOIN dba_datapump_sessions x ON (x.job_name = b.job_name)\n  LEFT JOIN v$session y ON (y.saddr = x.saddr)\n  LEFT JOIN v$sql z ON (y.sql_id = z.sql_id)\n  LEFT JOIN v$session_longops p ON (p.sql_id = y.sql_id)\n WHERE p.time_remaining &gt; 0   -- \u5c1a\u672a\u5b8c\u6210\u7684\u8fd8\u539f\n   AND y.module = &#039;Data Pump Worker&#039;;<\/code><\/pre>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_83e93d90e8655b4425805af09c7970e9.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_83e93d90e8655b4425805af09c7970e9.jpg\" alt=\"\" \/><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_%E9%80%9A%E8%BF%87impdp%E5%91%BD%E4%BB%A4%E7%9A%84%E5%8F%82%E6%95%B0ATTACH\"><\/span>2. \u901a\u8fc7impdp\u547d\u4ee4\u7684\u53c2\u6570ATTACH<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u5177\u4f53\u7684\u65b9\u6cd5\u5982\u4e0b\uff1a<\/p>\n<ol>\n<li>\u4f7f\u7528oracle\u7528\u6237\u767b\u5f55\u64cd\u4f5c\u7cfb\u7edf<\/li>\n<li>\u6267\u884c\u547d\u4ee4\uff1a<code>impdp attach=SYS_IMPORT_SCHEMA_01<\/code><\/li>\n<li>\u8fdb\u5165<code>Import&gt;<\/code> \u63d0\u793a\u7b26<\/li>\n<li>\u6267\u884c\u547d\u4ee4<code>status<\/code>\u67e5\u770bimpdp\u6b63\u5728\u505a\u7684\u5185\u5bb9<\/li>\n<\/ol>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_ce754c884fa9550f03721f258203598a.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_ce754c884fa9550f03721f258203598a.jpg\" alt=\"\" \/><\/a><br \/>\n\u65b0\u5f00\u4e00\u4e2a\u64cd\u4f5c\u7cfb\u7edf\u8fde\u63a5\u3002<\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_0416fac4de85c8f840255fedf2be3689.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_0416fac4de85c8f840255fedf2be3689.jpg\" alt=\"\" \/><\/a><br \/>\n\u4e0a\u56fe\u4e3a\u6b63\u5728\u5904\u7406\u6570\u636e\u3002<\/p>\n<p><a href=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_f9ce8b0a5a2b727403ad3b590779fa81.jpg\" data-fancybox=\"images\" data-fancybox=\"images\"><img decoding=\"async\" src=\"http:\/\/dba.qishuo.xin\/wp-content\/uploads\/2021\/08\/wp_editor_md_f9ce8b0a5a2b727403ad3b590779fa81.jpg\" alt=\"\" \/><\/a><br \/>\n\u4e0a\u56fe\u4e3a\u6b63\u5728\u5904\u7406\u7d22\u5f15\u3002<\/p>\n<p>\u53c2\u8003\uff1a<br \/>\n\u6f47\u6e58\u9690\u8005\u2013ORACLE \u5982\u4f55\u67e5\u770b\u7d22\u5f15\u91cd\u5efa\u8fdb\u5ea6\u60c5\u51b5: <a target=\"_blank\" href=\"https:\/\/www.cnblogs.com\/kerrycode\/p\/5673224.html\">https:\/\/www.cnblogs.com\/kerrycode\/p\/5673224.html<\/a><br \/>\nQueries to Monitor Datapump Jobs: <a target=\"_blank\" href=\"https:\/\/databaseinternalmechanism.com\/2016\/09\/13\/how-to-monitor-datapump-jobs\/\">https:\/\/databaseinternalmechanism.com\/2016\/09\/13\/how-to-monitor-datapump-jobs\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5f53\u6570\u636e\u5e93\u6267\u884cexpdp\/impdp\u547d\u4ee4\u7684\u65f6\u5019\uff0c\u5982\u679c&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,2],"tags":[],"class_list":["post-314","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=314"}],"version-history":[{"count":15,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/314\/revisions"}],"predecessor-version":[{"id":1548,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=\/wp\/v2\/posts\/314\/revisions\/1548"}],"wp:attachment":[{"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=314"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dba.qishuo.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}