Re: IMPDP Interactive mode question

From: Powell, Mark <>
Date: Wed, 9 Sep 2020 14:50:33 +0000
Message-ID: <>

This is a bit late but you can query the status of datapump via views such as dba_datapump_jobs and dba_datapump_sessions. If you join these views to V$SESSION and V$SQL you can pull the SQL in use at the time of the query.

Mark Powell
Database Administration
(313) 592-5148

From: <> on behalf of kunwar singh <> Sent: Wednesday, September 2, 2020 8:13 PM To: Mikhail Velikikh <> Cc: ORACLE-L <>; Sayan Malakshinov <>; Woody McKay <> Subject: Re: IMPDP Interactive mode question

Thank you all for suggestions !

On Wed, Sep 2, 2020 at 3:24 AM Mikhail Velikikh <<>> wrote: You can attach to a job and enter STATUS=<frequency_in_seconds> to display the status of the job every N-seconds:<>

The following example displays the current job status, and changes the logging mode display interval to two minutes (120 seconds).

Import> STATUS=120

On Wed, 2 Sep 2020 at 00:09, Sayan Malakshinov <<>> wrote: I would created pipelined function with a loop with dbms_datapump.attach, get_status, `pipe row`, detach and `exit when...` and just select from it in sqlplus/sqlcl script

ср, 2 сент. 2020 г., 1:38 Woody McKay <<>>: I just keep entering STATUS without ever exiting. You could do a cron'd script that attaches and grabs the status and write to a file or xmail you.

On Tue, Sep 1, 2020 at 5:24 PM kunwar singh <<>> wrote: Hi Listers,
Is there a way to check with the status of impdp in interactive mode every few minutes and don't need to type "EXIT" manually. Basically I want to automate the monitoring of big imports.

impdp scott/tiger attach=SYS_IMPORT_TABLE_01

Import> exit ---I don't want to keep logging in and typing 'exit' to monitor progress.

I searched the documentation/googled for such an option and didnt find one. But I am not impdp expert and could be missing something obvious.







-- Received on Wed Sep 09 2020 - 16:50:33 CEST

Original text of this message