Datapump jobs find in Oracle Database
desc dba_datapump_jobs;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER_NAME VARCHAR2(128)
JOB_NAME VARCHAR2(128)
OPERATION VARCHAR2(128)
JOB_MODE VARCHAR2(128)
STATE VARCHAR2(128 CHAR)
DEGREE NUMBER
ATTACHED_SESSIONS NUMBER
DATAPUMP_SESSIONS NUMBER
set linesize 190
col OWNER_NAME for a30
col JOB_NAME for a30
col STATE for a30
select OWNER_NAME,JOB_NAME,STATE from dba_datapump_jobs;
Comments
Post a Comment