DBA_DATAPUMP_JOBS identifies all active Data Pump jobs in the database, regardless of their state, on an instance (or on all instances for Real Application Clusters). It also show all Data Pump master tables not currently associated with an active job.
USER_DATAPUMP_JOBS displays the Data Pump jobs owned by the current user. This view does not display the OWNER_NAME column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER_NAME |
VARCHAR2(30) |
User that initiated the job | |
JOB_NAME |
VARCHAR2(30) |
User-supplied name for the job (or the default name generated by the server) | |
OPERATION |
VARCHAR2(30) |
Type of job | |
JOB_MODE |
VARCHAR2(30) |
Mode of job | |
STATE |
VARCHAR2(30) |
Current job state | |
DEGREE |
NUMBER |
Number of worker processes performing the operation | |
ATTACHED_SESSIONS |
NUMBER |
Number of sessions attached to the job | |
DATAPUMP_SESSIONS |
NUMBER |
Number of Data Pump sessions participating in the job |
See Also:
"USER_DATAPUMP_JOBS"