Skip to end of metadata
Go to start of metadata
  • get a list of running data pump jobs:

SET lines 200
COL owner_name FORMAT a10;
COL job_name FORMAT a20
COL state FORMAT a11
COL operation LIKE state
COL job_mode LIKE state
SELECT owner_name, job_name, operation, job_mode,
state, attached_sessions
FROM dba_datapump_jobs
WHERE job_name NOT LIKE 'BIN$%'
ORDER BY 1,2;

  • Attach to job with expdp:

$ expdp \"/ as sysdba\" ATTACH=SYS_EXPORT_FULL_02

Export: Release 10.2.0.4.0 - 64bit Production on Friday, 04 November, 2011 15:17:29

Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
Job: SYS_EXPORT_FULL_02
Owner: SYS
Operation: EXPORT
Creator Privs: TRUE
GUID: B0E4EE300882705AE044000000000000
Start Time: Friday, 04 November, 2011 10:00:06
Mode: FULL
Instance: mtb2p
Max Parallelism: 1
EXPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND '/******** AS SYSDBA' parfile=/oracle/dbsystem/Jan/expdp_mtb2p.par
FLASHBACK_TIME 11-NOV-04 10:00:07 AM
State: EXECUTING
Bytes Processed: 230,108,768,760
Percent Done: 16
Current Parallelism: 1
Job Error Count: 0
Dump File: /oracle/export1/mtb2p/mtb2p_migration1.dmp
size: 858,993,459,200
bytes written: 230,129,483,776
Dump File: /oracle/export2/mtb2p/mtb2p_migration2.dmp
size: 858,993,459,200
bytes written: 4,096
Dump File: /oracle/export3/mtb2p/mtb2p_migration3.dmp
size: 858,993,459,200
bytes written: 4,096
Dump File: /oracle/export4/mtb2p/mtb2p_migration4.dmp
size: 858,993,459,200
bytes written: 4,096
Worker 1 Status:
State: EXECUTING
Object Schema: MTB2_HL
Object Name: T_IL_TISYS_SHIPMENT
Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Completed Objects: 5
Total Objects: 1,483
Completed Rows: 161,242,543
Worker Parallelism: 1

  • Kill job in interactive shell

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