Howto Clear Stuck Data Pump Jobs Quickly
Submitted by gpmilliken on Mon, 04/18/2011 - 23:41
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;
declare
h1 number;
BEGIN
-- Format: DBMS_DATAPUMP.ATTACH('[job_name]','[owner_name]');
h1 := DBMS_DATAPUMP.ATTACH('SYS_EXPORT_SCHEMA_01','SYS');
DBMS_DATAPUMP.STOP_JOB (h1,1,0);
END;
/
-- drop the table listed in the query above, example below. Will be named differently for imports
DROP TABLE SYS.SYS_EXPORT_SCHEMA_01;
»
- gpmilliken's blog
- Login to post comments
