How To Drop Orfhaned Datapump Jobs

You can see the orphaned jobs by query the dba_datapump_jobs

 
SQL> select * from dba_datapump_jobs;

OWNER_NAME                     JOB_NAME                       OPERATION                      JOB_MODE                       STATE                              DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------- ----------------- -----------------
ANTONION                       SYS_EXPORT_SCHEMA_05           EXPORT                         SCHEMA                         NOT RUNNING                             0                 0                 0
ANTONION                       SYS_EXPORT_SCHEMA_01           EXPORT                         SCHEMA                         NOT RUNNING                             0                 0                 0
ANTONION                       SYS_EXPORT_SCHEMA_04           EXPORT                         SCHEMA                         NOT RUNNING                             0                 0                 0
ANTONION                       SYS_EXPORT_SCHEMA_02           EXPORT                         SCHEMA                         NOT RUNNING                             0                 0                 0
ANTONION                       SYS_EXPORT_SCHEMA_06           EXPORT                         SCHEMA                         NOT RUNNING                             0                 0                 0
ANTONION                       SYS_EXPORT_SCHEMA_03           EXPORT                         SCHEMA                         NOT RUNNING                             0                 0                 0

6 rows selected.

 

Now you can drop the table directly;

SQL> drop table SYS_EXPORT_SCHEMA_01;

Table dropped.

SQL> drop table SYS_EXPORT_SCHEMA_02;

Table dropped.

SQL> drop table SYS_EXPORT_SCHEMA_03;

Table dropped.

SQL> drop table SYS_EXPORT_SCHEMA_04;

Table dropped.

SQL> drop table SYS_EXPORT_SCHEMA_05;

Table dropped.

SQL> drop table SYS_EXPORT_SCHEMA_06;

Table dropped.

 

You can check the result by query the table again;

SQL> select * from dba_datapump_jobs;

no rows selected

 

If you are using the recycle bin it show the job name with the prefix BIN$. In this case purge the table;

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s