Exclude DBMS_SCHEDULER Jobs from expdp?

You have never thought about excluding DBMS_SCHEDULER jobs from a Data Pump export? Me neither but I’ve recently got a copy of an email for such a customer case from Roy who owns Data Pump as well. And this is the code example from Dean Gagne:


exclude=procobj:"IN (SELECT NAME FROM sys.OBJ$ WHERE TYPE# IN
  • This will work only on export
  • It’s an all or nothing approach

Quite interesting, isn’t it?

Share this:

One thought on “Exclude DBMS_SCHEDULER Jobs from expdp?

  1. PS: Update on Feb 8, 2017 – thanks to Jurjis Oleinikovs:

    To include DBMS_SCHEDULER jobs during datapump import, "include=PROCOBJ" can be used.

Leave a Reply

Your email address will not be published. Required fields are marked *

* Checkbox to comply with GDPR is required


I agree

This site uses Akismet to reduce spam. Learn how your comment data is processed.