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