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
No comments:
Post a Comment