Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
DBA_DATAPUMP_JOBS
displays all Data Pump jobs in the database.
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) |
Name of the job | |
OPERATION |
VARCHAR2(30) |
Type of operation being performed | |
JOB_MODE |
VARCHAR2(30) |
Mode of operation being performed | |
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 |