Data Pump Parameter-Kill_job

Data Pump Parameters-Kill_job

[oracle@oracle11g ~]$ expdp system/oracle directory=test_dir full=y dumpfile=full2.dmp logfile=full2.log parallel=2

Export: Release 11.2.0.3.0 – Production on Mon Aug 31 12:04:17 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting “SYSTEM”.”SYS_EXPORT_FULL_01″:  system/******** directory=test_dir full=y dumpfile=full2.dmp logfile=full2.log parallel=2
Estimate in progress using BLOCKS method…
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Export> status

Job: SYS_EXPORT_FULL_01
  Operation: EXPORT
  Mode: FULL
  State: EXECUTING
  Bytes Processed: 0
  Current Parallelism: 2
  Job Error Count: 0
  Dump File: /u01/dump/full2.dmp
    bytes written: 4,096

Worker 1 Status:
  Process Name: DW00
  State: EXECUTING
  Object Schema: SCOTT
  Object Name: DON
  Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
  Completed Objects: 1,398
  Total Objects: 1,398
  Worker Parallelism: 1

Worker 2 Status:
  Process Name: DW01
  State: EXECUTING
  Object Schema: SCOTT
  Object Name: DON
  Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
  Completed Objects: 1
  Total Objects: 1,398
  Worker Parallelism: 1

Export> kill_job
Are you sure you wish to stop this job ([yes]/no): y


[oracle@oracle11g ~]$ ps -ef|grep exdp
oracle    9388  6500  0 12:08 pts/4    00:00:00 grep exdp

  • August 31, 2015 | 14 views
  • Comments