之前做数据库expdp, 一直卡在
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
然后我看了job,发现:
SYS@iris> select * from dba_datapump_jobs;
OWNER_NAME JOB_NAME OPERATION
------------------------------ ------------------------------ ------------------------------------------------------------------------------------------
JOB_MODE STATE DEGREE ATTACHED_SESSIONS
------------------------------------------------------------------------------------------ ------------------------------ ---------- -----------------
DATAPUMP_SESSIONS
-----------------
SYS SYS_EXPORT_SCHEMA_01 EXPORT
SCHEMA EXECUTING 8 1
10
SYS SYS_EXPORT_SCHEMA_02 EXPORT
SCHEMA STOP PENDING 8 0
9
SYSTEM SYS_EXPORT_SCHEMA_02 EXPORT
SCHEMA NOT RUNNING 0 0
0
我想停止所有的job,但是不行啊,
oracle@stageip1:/export/oracle > expdp system/iris attach=SYS_EXPORT_SCHEMA_01
Export: Release 11.2.0.3.0 - Production on Wed Jul 16 01:21:00 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 405
ORA-31638: cannot attach to job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-31632: master table "SYSTEM.SYS_EXPORT_SCHEMA_01" not found, invalid, or inaccessible
ORA-00942: table or view does not exist
oracle@stageip1:/export/oracle >
oracle@stageip1:/export/oracle > expdp system/iris attach=SYS_EXPORT_SCHEMA_02
Export: Release 11.2.0.3.0 - Production on Wed Jul 16 01:21:13 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
ORA-39002: invalid operation
ORA-39000: bad dump file specification
ORA-39140: dump file "/u01/app/oracle/product/11.2.0/dbhome_3/rdbms/log/Iris_U.dmp" belongs to job "SYS"."SYS_EXPORT_SCHEMA_02"
我的问题是:
怎么停止所有的job呢?
急求,谢谢!!