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
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
