Re: IMPDP Interactive mode question

Thank you all for suggestions !

On Wed, Sep 2, 2020 at 3:24 AM Mikhail Velikikh <mvelikikh_at_gmail.com> wrote:

> 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
>>>
>> --
Cheers,
Kunwar

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