Database 11g

Thursday, June 9, 2016

How to drop data pump job in oracle11g



SQL> select * from dba_datapump_jobs;


OWNER       JOB_NAME                OPERATION     JOB_MODE   STATE               DEGREE ATACHED_SESSIONS DATAPUMP_SESSIONS
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SYSTEM    SYS_IMPORT_FULL_03   IMPORT          FULL          EXECUTING              1                         1                         3
SYSTEM    SYS_IMPORT_FULL_01   IMPORT          FULL          NOT RUNNING          0                          0                         0
SYSTEM    SYS_EXPORT_FULL_01   EXPORT         FULL          NOT RUNNING          0                          0                         0



SQL> DROP TABLE SYSTEM.SYS_IMPORT_FULL_01;

Table dropped.


SQL> DROP TABLE SYSTEM.SYS_EXPORT_FULL_01;

Table dropped.



Happy Learning....











No comments:

Post a Comment