Samedi 6 août 2011 6 06 /08 /Août /2011 15:26

IMPORT / EXPORT JOBS DATA PUMP

Lister les jobs IMPORT EXPORT DATA PUMP.

Comment voir les jobs import data pump en cours. ?
Comment voir les jobs export data pump en cours. ?
Comment voir le statut des jobs data pump en cours. ?

DBA_DATAPUMP_JOBS.

Les tâches Data Pump ( impdp et expdp ) peuvent être contrôlées à l'aide de la vues DBA_DATAPUMP_JOBS.

Voir les jobs DATA PUMP.

SQL> COL OWNER_NAME FORMAT A11
SQL> COL JOB_NAME   FORMAT A18
SQL> COL OPERATION  FORMAT A11
SQL> COL JOB_MODE   FORMAT A9
SQL> COL STATE      FORMAT A10
SQL> SET LINESIZE 120

SQL> SELECT * FROM DBA_DATAPUMP_JOBS;

OWNER_NAME  JOB_NAME           OPERATION  JOB_MODE  STATE     DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
----------- ------------------ ---------- --------- --------- ------ ----------------- -----------------
SYSTEM      SYS_EXPORT_FULL_01 EXPORT     FULL      EXECUTING      1                 1              3

SQL>

Purger un job DATA PUMP.

SQL> COL OWNER_NAME FORMAT A11
SQL> COL JOB_NAME   FORMAT A18
SQL> COL OPERATION  FORMAT A11
SQL> COL JOB_MODE   FORMAT A9
SQL> COL STATE      FORMAT A10
SQL> SET LINESIZE 120

SQL> SELECT * FROM DBA_DATAPUMP_JOBS;

OWNER_NAME JOB_NAME           OPERATION  JOB_MODE  STATE       DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
---------- ------------------ ---------- --------- ----------- ------ ----------------- -----------------
SYSTEM     SYS_EXPORT_FULL_01 EXPORT     FULL      NOT RUNNING      0                 0              0

SQL>
SQL> DROP TABLE SYSTEM.SYS_EXPORT_FULL_01 PURGE;

Table dropped.

SQL>