How to Filter Scheduler Jobs Via Data Pump API
(Doc ID 2014494.1)
Last updated on MARCH 27, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Goal
The Data Pump API does not have the possibility to filter out jobs created with the DBMS scheduler.
Therefore there is no dbms_datapump.metadata_filter syntax option that achieves this.
This has been investigated in the unpublished Bug 20864810 - DATAPUMP API DOESN'T FILTER SCHEDULER JOBS
which has been closed with status 'Not a Bug'.
To make this even more clear, the next documentation bug has been opened
Bug 21133430 - CUSTOMER WANTS TO EXCLUDE ALL AND SPECIFIC SCHEDULER JOBS VIA THE DATAPUMP API
to update the documentation
https://docs.oracle.com/database/121/ARPLS/d_metada.htm#ARPLS026
Any syntax of the type
is *not* effective for this purpose (excluding scheduler jobs).
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |