Re: IMPDP Interactive mode question
Date: Wed, 9 Sep 2020 14:50:33 +0000
Message-ID: <DM6PR01MB5929F5D2F2B8D8AA9F082A3CCE260_at_DM6PR01MB5929.prod.exchangelabs.com>
This is a bit late but you can query the status of datapump via views such as dba_datapump_jobs and dba_datapump_sessions. If you join these views to V$SESSION and V$SQL you can pull the SQL in use at the time of the query.
Mark Powell
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of kunwar singh <krishsingh.111_at_gmail.com> Sent: Wednesday, September 2, 2020 8:13 PM To: Mikhail Velikikh <mvelikikh_at_gmail.com> Cc: ORACLE-L <oracle-l_at_freelists.org>; Sayan Malakshinov <xt.and.r_at_gmail.com>; Woody McKay <woody.mckay_at_gmail.com> Subject: 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<mailto: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<https://clicktime.symantec.com/3UptX9RviBv3SCMutviJ3f17Vc?u=https%3A%2F%2Fdocs.oracle.com%2Fen%2Fdatabase%2Foracle%2Foracle-database%2F19%2Fsutil%2Fdatapump-import-utility.html%23GUID-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<mailto: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<mailto: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<mailto: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
Received on Wed Sep 09 2020 - 16:50:33 CEST