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@xxxxxxxxx>:
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@xxxxxxxxx>
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