Re: Scheduler jobs & DBMS_DATAPUMP
Date: Wed, 8 Jul 2020 13:37:28 +0000
Message-ID: <DM6PR20MB2953F7FF8EA3CEDF8C256DA5FF670_at_DM6PR20MB2953.namprd20.prod.outlook.com>
Sumit
We were asked during Import Scheduler job should not start. We set job_queue_processes=0 before import. Post import verify/recreate jobs then reset job_queue_processes.
I don’t know your exact requirement thought let me share
HTH
Karth
Get Outlook for iOS<https://aka.ms/o0ukef>
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Sumit Kumar T <dba.tyagisumit_at_gmail.com> Sent: Wednesday, July 8, 2020 7:22:19 AM To: Ilmar Kerm <ilmar.kerm_at_gmail.com> Cc: Oracle L <oracle-l_at_freelists.org> Subject: Re: Scheduler jobs & DBMS_DATAPUMP
Yes these docs say it not possible via dbms_datapump api.
On Tue, Jul 7, 2020, 01:07 Ilmar Kerm <ilmar.kerm_at_gmail.com<mailto:ilmar.kerm_at_gmail.com>> wrote: Hi
The following MOS notes discuss this topic: How to Filter Scheduler Jobs Via Data Pump API (Doc ID 2014494.1) How To Exclude Scheduler Job From Data Pump Export (expdp) (Doc ID 1414478.1)
On Mon, Jul 6, 2020 at 9:28 PM Sumit Kumar T <dba.tyagisumit_at_gmail.com<mailto:dba.tyagisumit_at_gmail.com>> wrote: Hi All,
Is there any way to exclude import of dbms scheduler jobs while importing schema using dbms_datapump package ? Has anyone faced this issue?
--
Ilmar Kerm
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 08 2020 - 15:37:28 CEST