04.08.2017
Oracle Data Pump
Export Killen
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$%';