Re: Scheduler jobs & DBMS_DATAPUMP

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_at_gmail.com> wrote:

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