martedì 23 giugno 2009

How to display all Data Pump jobs in the database

select * from dba_datapump_jobs

Column Datatype 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


Related View
USER_DATAPUMP_JOBS displays the Data Pump jobs owned by the current user. This view does not display the OWNER_NAME column.

Nessun commento:

Posta un commento