Re: IMPDP Interactive mode question

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 2 Sep 2020 02:07:12 +0300
Message-ID: <CAOVevU42DKUQth2+fUzhud=GfJaA6nPQhi=T-vHF=TikW6VJLQ_at_mail.gmail.com>



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
Received on Wed Sep 02 2020 - 01:07:12 CEST

Original text of this message