While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours. Which view would you query to determine the…

The correct answer is D. DBA_DATAPUMP_JOBS. When a Datapump Export or Import session is launched, a Datapump Job is automatically tarted. This way, we can: detach from and reattach to long-running jobs without affecting the job itself. monitor jobs from multiple locations stop a job: suspend it temporarily to leave other…

Data Movement

Question

While exporting data with Data Pump, you find that the export takes longer than expected. You decide to stop the job and restart it during off-peak hours. Which view would you query to determine the name and status of the stopped job?

Options

ADBA_JOBS
BV$SESSION
CV$SESSION_LONGOPS
DDBA_DATAPUMP_JOBS
EDBA_DATAPUMP_SESSIONS

How the community answered

(34 responses)

A
3% (1)
B
3% (1)
C
15% (5)
D
71% (24)
E
9% (3)

Explanation

When a Datapump Export or Import session is launched, a Datapump Job is automatically tarted. This way, we can:* detach from and reattach to long-running jobs without affecting the job itself. * monitor jobs from multiple locations * stop a job: suspend it temporarily to leave other applications requesting more resources to get them restart itlater * kill any Datapump job anytime * see the progress of the import or export operations

Topics

#Data Pump#DBA_DATAPUMP_JOBS#export job#job status

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice