使用 Oracle Datapump API 实现数据导出 .(14)_网站编程

AND c.SID = a.session_id

13 AND c.SID = d.SID;

OBJECT_NAME||''||LOCKED_MODE||''||CTIME||''||C.SID||''||SERIAL#

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

JOB_EXP 3 552 1075 799

scott@CNMMBO> alter system kill session '1075,799';

System altered.

scott@CNMMBO> drop table job_exp purge; -->删除表之后再次进行导出

Table dropped.

9、使用视图监控datapump状态

scott@CNMMBO> col owner_name format a15

scott@CNMMBO> col operation format a15

scott@CNMMBO> col state format a20

scott@CNMMBO> select owner_name,job_name,operation,job_mode,state,degree from dba_datapump_jobs;

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE

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

SCOTT JOB_EXP1 EXPORT SCHEMA EXECUTING 1

10、使用下面的过程设定并行度

DBMS_DATAPUMP.set_parallel (hand, 1);

11、上述操作所在的演示环境

scott@CNMMBO> select * from v$version where rownum<2;

BANNER

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

使用 Oracle Datapump API 实现数据导出 .(14)