oracle dba_datapump_jobs,dba_datapump_jobs里面没有RUNNING的JOB如何删除

最新推荐文章于 2021-04-11 23:32:52 发布

他们迂回误会

最新推荐文章于 2021-04-11 23:32:52 发布

阅读量319

点赞数

文章标签： oracle dba_datapump_jobs

OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS

------------------------------ ------------------------------ ------------------------------------------------------------ ------------------------------------------------------------ ------------------------------ ---------- ----------------- -----------------

SYSTEM SYS_IMPORT_FULL_03 IMPORT FULL EXECUTING 1 1 3

SYSTEM SYS_EXPORT_FULL_08 EXPORT FULL NOT RUNNING 0 0 0

SYSTEM SYS_EXPORT_FULL_01 EXPORT FULL NOT RUNNING 0 0 0

SYSTEM SYS_IMPORT_FULL_01 IMPORT FULL NOT RUNNING 0 0 0

SYSTEM SYS_EXPORT_FULL_07 EXPORT FULL NOT RUNNING 0 0 0

TSKFTEST SYS_IMPORT_FULL_01 IMPORT FULL NOT RUNNING 0 0 0

SYSTEM SYS_EXPORT_FULL_02 EXPORT FULL NOT RUNNING 0 0 0

SYSTEM SYS_IMPORT_FULL_02 IMPORT FULL NOT RUNNING 0 0 0

$ impdp system/yanxj attach=SYS_IMPORT_FULL_01

Import: Release 10.2.0.3.0 - 64bit Production on Wednesday, 03 November, 2010 13:53:12

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options