{"id":28,"date":"2009-01-07T10:17:14","date_gmt":"2009-01-07T10:17:14","guid":{"rendered":"https:\/\/www.spotonoracle.com\/?p=28"},"modified":"2016-05-10T10:17:41","modified_gmt":"2016-05-10T10:17:41","slug":"exportimport-scheduler-jobs","status":"publish","type":"post","link":"https:\/\/www.spotonoracle.com\/?p=28","title":{"rendered":"Export\/Import Scheduler Jobs"},"content":{"rendered":"<p>The Oracle Utilities documentation (data pump, sql*ldr, etc.) is a bit light with regards to the object types and the corresponding names used in the INCLUDE parameter as it only refers to DATABASE_EXPORT_OBJECTS, SCHEMA_EXPORT_OBJECTS and TABLE_EXPORT_OBJECTS views which apparently do not have a very useful description in the COMMENTS column for all object paths.<\/p>\n<p>On the web there are several resources showing how to import Oracle Scheduler jobs from a schema dump by creating the sql file (using SQLFILE parameter) and then extracting the relevant DBMS_SCHEDULER.CREATE_JOB commands from the DDL sql file. This seems a bit cumbersome to automate. Fortunately there is a much simpler way to do this using the right object type in the INCLUDE parameter: PROCOBJ<\/p>\n<p>Assuming schema_dump.dmp contains a complete schema dump and you just want to import the Scheduler jobs run following impdp command:<\/p>\n<pre class=\"brush: sql; collapse: false; title: ; wrap-lines: false; notranslate\" title=\"\">\r\n$ impdp &lt;username&gt;\/&lt;password&gt; dumpfile=schema_dump.dmp include=PROCOBJ\r\n<\/pre>\n<p>Foot note: All tests have been run on a 10g 10.2.0.4 database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Oracle Utilities documentation (data pump, sql*ldr, etc.) is a bit light with regards to the object types and the corresponding names used in the INCLUDE parameter as it only refers to DATABASE_EXPORT_OBJECTS, SCHEMA_EXPORT_OBJECTS and TABLE_EXPORT_OBJECTS views which apparently do not have a very useful description in the COMMENTS column for all object paths. On [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-28","post","type-post","status-publish","format-standard","hentry","category-data-pump"],"_links":{"self":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/28","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=28"}],"version-history":[{"count":2,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/28\/revisions"}],"predecessor-version":[{"id":30,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/28\/revisions\/30"}],"wp:attachment":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=28"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=28"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}