[Home] [Help] [Dependency Information]
Object Name: | USER_DATAPUMP_JOBS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Datapump jobs for current user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NAME | VARCHAR2 | (128) | Job name | |
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 | ||
DATAPUMP_SESSIONS | NUMBER | Number of Datapump sessions participating in the job |
Cut, paste (and edit) the following text to query this object:
SELECT JOB_NAME
, OPERATION
, JOB_MODE
, STATE
, DEGREE
, ATTACHED_SESSIONS
, DATAPUMP_SESSIONS
FROM SYS.USER_DATAPUMP_JOBS;
|
|
|