Re: IMPDP Interactive mode question

You can attach to a job and enter STATUS=<frequency_in_seconds> to display the status of the job every N-seconds:
https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/datapump-import-utility.html#GUID-DDF7E228-B0F9-4112-96D2-DA7063B79730

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 <xt.and.r_at_gmail.com> 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 <woody.mckay_at_gmail.com>:
>
>> 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 <krishsingh.111_at_gmail.com>
>> 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.
>>>
>>> --
>>> Cheers,
>>> Kunwar
>>>
>>
>>
>> --
>> Sincerely,
>>
>> WoodyMcKay
>>
>

--
http://www.freelists.org/webpage/oracle-l