Oracle Data Pump

Export Killen

JOB_NAME vom SQL

SELECT OWNER_NAME, JOB_NAME, OPERATION, JOB_MODE, STATE FROM DBA_DATAPUMP_JOBS;


OWNER_NAME JOB_NAME             OPERATION JOB_MODE STATE     DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
---------- -------------------- --------- -------- --------- ------ ----------------- ------------------
SYSTEM     SYS_EXPORT_SCHEMA_01 EXPORT    SCHEMA   EXECUTING 16     1                 28

JOB killen oder stoppen

expdp \"/ as sysdba\" \ ATTACH={JOB_NAME}

Export> STOP_JOB=IMMEDIATE
Export> KILL_JOB
Are you sure you wish to stop this job ([yes]/no): yes

CLEANUP DATAPUMP JOBS

SELECT owner_name, job_name, operation FROM dba_datapump_jobs where state='NOT RUNNING' and attached_sessions=0;
SELECT 'purge table ' || owner_name || '.' || job_name || ';' FROM dba_datapump_jobs WHERE state='NOT RUNNING' and attached_sessions=0;
SELECT 'drop table '  || owner_name || '.' || job_name || ';' FROM dba_datapump_jobs WHERE state='NOT RUNNING' and attached_sessions=0;

Prüfen ob externe Tabellen für Datapump erstellt wurden

select  object_name, created from dba_objects where object_name like 'ET$%';