ora10Ну да лано, в общем, как я понимаю, нормального штатного средства для данной ситуации нет. Остаётся только мой скрипт выше.
И да, доку я прочитал, думал может что-то упустил, пока вроде нет..
Имитируем dba_datapump_jobs state=DEFINING:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
SQL> select *
2 from v$version
3 /
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for 64-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> DECLARE
2 h1 NUMBER;
3 BEGIN
4 h1 := DBMS_DATAPUMP.OPEN('EXPORT','SCHEMA',NULL,'EXAMPLE1','LATEST');
5 END;
6 /
PL/SQL procedure successfully completed.
SQL> SELECT *
2 FROM DBA_DATAPUMP_JOBS
3 /
OWNER_NAME JOB_NAME
------------------------------ ------------------------------
OPERATION JOB_MODE
------------------------------ ------------------------------
STATE DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
SCOTT EXAMPLE1
EXPORT SCHEMA
DEFINING 1 1 2
SQL>
Теперь:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
C:\Users\sy47755>expdp JOB_NAME=EXAMPLE1
Export: Release 11.2.0.3.0 - Production on Tue Jun 24 09:52:33 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: scott@orcl
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31634: job already exists
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 1016
ORA-31637: cannot create job EXAMPLE1 for user SCOTT
C:\Users\sy47755>
Из другой сессии прибиваем job EXAMPLE1:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
SQL> BEGIN
2 DBMS_DATAPUMP.STOP_JOB(
3 DBMS_DATAPUMP.ATTACH(
4 'EXAMPLE1',
5 'SCOTT'
6 ),
7 1
8 );
9 END;
10 /
PL/SQL procedure successfully completed.
SQL> SELECT *
2 FROM DBA_DATAPUMP_JOBS
3 /
no rows selected
SQL>
SY.
