If you have a naming convention for your jobs or can somehow identify them
by name, then you can exclude them using the NAME_EXPR filter:
dbms_datapump.metadata_filter(h1, 'NAME_EXPR', 'NOT LIKE ''SCJ%''',
'PROCOBJ');
The command above is for the database in which all jobs are named with a
prefix SCJ, such as SCJ_JOB1, SCJ_JOB2, etc.
On Wed, 8 Jul 2020 at 12:24, Sumit Kumar T <dba.tyagisumit@xxxxxxxxx> wrote:
Yes these docs say it not possible via dbms_datapump api.
On Tue, Jul 7, 2020, 01:07 Ilmar Kerm <ilmar.kerm@xxxxxxxxx> 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@xxxxxxxxx>
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
