[Home] [Help] [Dependency Information]
Object Name: | GV_$DATAPUMP_JOB |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
JOB_ID | RAW | (16) | ||
JOB_NAME | VARCHAR2 | (30) | ||
OWNER_NAME | VARCHAR2 | (30) | ||
MSG_CTRL_QUEUE | VARCHAR2 | (30) | ||
STATUS_QUEUE | VARCHAR2 | (30) | ||
OPERATION | VARCHAR2 | (30) | ||
JOB_MODE | VARCHAR2 | (30) | ||
MASTER_ID | NUMBER | |||
STATE | VARCHAR2 | (30) | ||
WORKERS | NUMBER | |||
FLAGS | NUMBER | |||
SERIALNUM | NUMBER | |||
QUEUE_TABNUM | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, JOB_ID
, JOB_NAME
, OWNER_NAME
, MSG_CTRL_QUEUE
, STATUS_QUEUE
, OPERATION
, JOB_MODE
, MASTER_ID
, STATE
, WORKERS
, FLAGS
, SERIALNUM
, QUEUE_TABNUM
, CON_ID
FROM SYS.GV_$DATAPUMP_JOB;
|
|
|