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.par:

exclude=procobj:"IN (SELECT NAME FROM sys.OBJ$ WHERE TYPE# IN
(47,48,66,67,68,69,71,72,74))"
  • This will work only on export
  • It’s an all or nothing approach

Quite interesting, isn’t it?

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 *