{"id":37197,"date":"2025-02-21T06:50:00","date_gmt":"2025-02-21T05:50:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=37197"},"modified":"2025-02-20T23:12:08","modified_gmt":"2025-02-20T22:12:08","slug":"why-data-pump-fails-to-import-scheduler-programs","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/","title":{"rendered":"Why Data Pump Fails to Import Scheduler-Programs"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-here-is-the-how-to-of-scripting-them-instead\">Here is the How To of scripting them instead<\/h2>\n\n\n\n<p>Oracle Data Pump can import simple programs without arguments, but it fails when handling Scheduler-Programs that contain arguments. This has been a persistent issue with no official resolution. <br>Since this was a critical challenge in a recent project of mine, I\u2019d like to share my solution.<\/p>\n\n\n\n<p>In rare cases, the scripts are available and can be reused, but when you need to dig through Change Requests, JIRA tickets or the Document Management System (DMS) because the developer has already retired, you\u2019re often left with no choice but to reengineer the solution.<\/p>\n\n\n\n<p>At first, I started with a schema-export and import which generated a log file with 15,000 lines and hundreds of error messages. I was puzzled by this message:<br>There were more of them, however I would like to use this single Scheduler-Program as example.<\/p>\n\n\n\n<h6 class=\"wp-block-heading\" id=\"h-here-s-an-example-of-an-error-message-i-encountered\">Here\u2019s an example of an error message I encountered:<\/h6>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n19-OCT-24 10:55:09.222: ORA-39083: Object type PROCOBJ:&quot;MMTK&quot;.&quot;MAIL_MMTK_PRG&quot; failed to create with error:\nORA-06550: line 8, column 265:\nPL\/SQL: ORA-00942: table or view does not exist\nORA-06550: line 8, column 21:\nPL\/SQL: SQL Statement ignored\nORA-06550: line 11, column 5:\nPLS-00364: loop index variable &#039;ARG&#039; use is invalid\nORA-06550: line 11, column 2:\nPL\/SQL: Statement ignored\n\nFailing sql is:\nBEGIN \ndbms_scheduler.create_program(&#039;&quot;MAIL_MMTK_PRG&quot;&#039;,&#039;STORED_PROCEDURE&#039;,\n&#039;PKG_JOBMMTK.prc_wmail&#039;\n,18, FALSE,\n&#039;Send Mail&#039;\n);\nDECLARE \nCURSOR prog_args IS SELECT replace(a.argument_name, &#039;&#039;&#039;&#039;, &#039;&#039;&#039;&#039;&#039;&#039;) arg_name,  a.argument_position position, a.argument_type type_name, a.metadata_attribute int_arg_type, a.default_anydata_value value, decode(a.out_argument,&#039;FALSE&#039;,0,&#039;TRUE&#039;,1) out_flag  FROM SYSTEM.SCHEDULER_PROGRAM_ARGS_TMP a  where a.owner=&#039;MMTK&#039; and  a.program_name=&#039;MAIL_MMTK_PRG&#039;;\n BEGIN\nFOR arg in prog_args LOOP\n IF arg.int_arg_type IS NULL THEN\n dbms_scheduler.define_anydata_argument(&#039;&quot;MAIL_MMTK_PRG&quot;&#039; , arg.position,  CASE WHEN arg.arg_name IS NULL THEN NULL ELSE \n     &#039;&quot;&#039;||arg.arg_name||&#039;&quot;&#039; END, arg.type_name, arg.value, arg.out_flag=1 );\n ELSE\n dbms_scheduler.define_metadata_argument(&#039;&quot;MAIL_MMTK_PRG&quot;&#039; ,arg.int_arg_type, arg.position, CASE WHEN arg.arg_name IS NULL THEN NULL ELSE \n     &#039;&quot;&#039;||arg.arg_name||&#039;&quot;&#039; END );\n END IF;\n END LOOP;\n END;\ndbms_scheduler.enable(&#039;&quot;MAIL_MMTK_PRG&quot;&#039;);COMMIT; END;\n\n<\/pre><\/div>\n\n\n<p>The first hint (ORA-00942) suggests a missing table or privilege, but which one?<br>Maybe the SYSTEM.SCHEDULER_PROGRAM_ARGS_TMP in the DECLARE-block? It does not exist. Sounds like a temporary view during import.<br>The second hint about variable \u2018ARG\u2019 is mysterious \u2013 though the loop variable appears syntactically correct, it still triggers an error. <br>Furthermore, in another Scheduler-Program, I found the same error.<br>Although the Scheduler-Programs worked fine in the existing environment, I could not import them. Missing tables or permissions as the reason for the errors could be excluded after some work.<br>Somewhere on the internet, I found the information, that this is an unsolved problem. A request for enhancement is pending \u2026<\/p>\n\n\n\n<p>Now, how can we script these Scheduler-Programs?<br>dbms-metadata? Good idea! Let\u2019s see what it delivers:<\/p>\n\n\n\n<h6 class=\"wp-block-heading\" id=\"h-to-extract-the-definition-of-the-scheduler-program-i-used-the-following-command\">To extract the definition of the Scheduler-Program, I used the following command:<\/h6>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect dbms_metadata.get_ddl(&#039;PROCOBJ&#039;,&#039;MAIL_MMTK_PRG&#039;,&#039;MMTK&#039;) from dual;\n\nBEGIN\n  dbms_scheduler.create_program(&#039;MAIL_MMTK_PRG&#039;,&#039;STORED_PROCEDURE&#039;,\n  &#039;PKG_JOBMMTK.prc_wmail&#039;, 18, FALSE, &#039;Send Mail&#039;\n);\nCOMMIT;\nEND;\n\/\n<\/pre><\/div>\n\n\n<p>Nice \ud83d\ude10<br>It retrieves the Scheduler-Program itself, but not its arguments \u2639<br>This is just the \u201cfailing sql\u201d we have seen in the error message above.<\/p>\n\n\n\n<h6 class=\"wp-block-heading\" id=\"h-using-user-scheduler-program-args-allows-us-to-reconstruct-missing-arguments\">Using USER_SCHEDULER_PROGRAM_ARGS allows us to reconstruct missing arguments<\/h6>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect argument_position, argument_name, argument_type, default_value \n from USER_SCHEDULER_PROGRAM_ARGS \n where  program_name = &#039;MAIL_MMTK_PRG&#039; order by   argument_position;\n\nARGUMENT_POSITION ARGUMENT_NAME      ARGUMENT_TYPE  DEFAULT_VALUE\n----------------- ------------------ -------------- --------------------\n                1 P_HOST             VARCHAR2       mailhost\n                2 P_DOMAIN           VARCHAR2       mycompany.com\n                3 P_PORTNUM          NUMBER         25\n                4 P_FROM             VARCHAR2\n                5 P_TO               VARCHAR2\n                6 P_CC               VARCHAR2\n                7 P_BCC              VARCHAR2\n                8 P_REPLYTO          VARCHAR2\n                9 P_SUBJECT          VARCHAR2\n               10 P_MSGTXT           VARCHAR2\n               11 P_CONTENTS         VARCHAR2\n               12 P_ATTACH           VARCHAR2\n               13 P_URL              VARCHAR2\n               14 P_TRACEMODE        VARCHAR2       N\n               15 P_MIMETYPE         VARCHAR2       text\/plain\n               16 P_DISPOSITION      VARCHAR2       attachment\n               17 P_CHARSET          VARCHAR2       iso-8859-1\n               18 P_TRANSFERTENCODE  VARCHAR2\n\n<\/pre><\/div>\n\n\n<p>I was not aware that Emails need to have 18 arguments, but ok<br>Now I started puzzling pieces. The syntax for an argument is:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ndbms_scheduler.define_program_argument(\n program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n argument_position =&gt; 1,\n argument_name     =&gt; &#039;P_HOST&#039;,\n argument_type     =&gt; &#039;VARCHAR2&#039;,\n default_value     =&gt; &#039;mailhost&#039;  );\n\n<\/pre><\/div>\n\n\n<p>copy this block 18 times and insert the values from listing above.<br>Yes, I could have done some clever dynamic-SQL \u2026<\/p>\n\n\n\n<p>At the end, the entire code block looks like that:<br>Before, you need to create the scheduler-program as seen above &#8211; of course &#8230;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nbegin\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 1,\n    argument_name     =&gt; &#039;P_HOST&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; &#039;mailhost&#039;  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 2,\n    argument_name     =&gt; &#039;P_DOMAIN&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; &#039;mycompany.com&#039;  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 3,\n    argument_name     =&gt; &#039;P_PORTNUM&#039;,\n    argument_type     =&gt; &#039;NUMBER&#039;,\n    default_value     =&gt; 25  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 4,\n    argument_name     =&gt; &#039;P_FROM&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 5,\n    argument_name     =&gt; &#039;P_TO&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 6,\n    argument_name     =&gt; &#039;P_CC&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 7,\n    argument_name     =&gt; &#039;P_BCC&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 8,\n    argument_name     =&gt; &#039;P_REPLYTO&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 9,\n    argument_name     =&gt; &#039;P_SUBJECT&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 10,\n    argument_name     =&gt; &#039;P_MSGTXT&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 11,\n    argument_name     =&gt; &#039;P_CONTENTS&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 12,\n    argument_name     =&gt; &#039;P_ATTACH&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 13,\n    argument_name     =&gt; &#039;P_URL&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 14,\n    argument_name     =&gt; &#039;P_TRACEMODE&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; &#039;N&#039;  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 15,\n    argument_name     =&gt; &#039;P_MIMETYPE&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; &#039;text\/plain&#039;  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 16,\n    argument_name     =&gt; &#039;P_DISPOSITION&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; &#039;attachment&#039;  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 17,\n    argument_name     =&gt; &#039;P_CHARSET&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; &#039;iso-8859-1&#039;  );\n  dbms_scheduler.define_program_argument(\n    program_name      =&gt; &#039;MAIL_MMTK_PRG&#039;,\n    argument_position =&gt; 18,\n    argument_name     =&gt; &#039;P_TRANSFERTENCODE&#039;,\n    argument_type     =&gt; &#039;VARCHAR2&#039;,\n    default_value     =&gt; NULL  );\ncommit;\nend;\n\/\n\nexec DBMS_SCHEDULER.ENABLE(name=&gt;&#039;MAIL_MMTK_PRG&#039;);\n\n<\/pre><\/div>\n\n\n<p>I hope this guide helps others facing the same issue. If you\u2019ve encountered this problem before or have alternative solutions, share your thoughts in the comments!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is the How To of scripting them instead Oracle Data Pump can import simple programs without arguments, but it fails when handling Scheduler-Programs that contain arguments. This has been a persistent issue with no official resolution. Since this was a critical challenge in a recent project of mine, I\u2019d like to share my solution. [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198,59],"tags":[240,3544,281,2473,3541,3536,3542,3543],"type_dbi":[],"class_list":["post-37197","post","type-post","status-publish","format-standard","hentry","category-database-management","category-oracle","tag-data-pump","tag-dbms_metadata","tag-dbms_scheduler","tag-import","tag-program-argument","tag-scheduler","tag-scheduler-job","tag-scheduler-program"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Why Data Pump Fails to Import Scheduler-Programs - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why Data Pump Fails to Import Scheduler-Programs\" \/>\n<meta property=\"og:description\" content=\"Here is the How To of scripting them instead Oracle Data Pump can import simple programs without arguments, but it fails when handling Scheduler-Programs that contain arguments. This has been a persistent issue with no official resolution. Since this was a critical challenge in a recent project of mine, I\u2019d like to share my solution. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-21T05:50:00+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Why Data Pump Fails to Import Scheduler-Programs\",\"datePublished\":\"2025-02-21T05:50:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/\"},\"wordCount\":429,\"commentCount\":1,\"keywords\":[\"Data pump\",\"dbms_metadata\",\"dbms_scheduler\",\"import\",\"program argument\",\"scheduler\",\"scheduler job\",\"scheduler program\"],\"articleSection\":[\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/\",\"name\":\"Why Data Pump Fails to Import Scheduler-Programs - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2025-02-21T05:50:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why Data Pump Fails to Import Scheduler-Programs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Why Data Pump Fails to Import Scheduler-Programs - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/","og_locale":"en_US","og_type":"article","og_title":"Why Data Pump Fails to Import Scheduler-Programs","og_description":"Here is the How To of scripting them instead Oracle Data Pump can import simple programs without arguments, but it fails when handling Scheduler-Programs that contain arguments. This has been a persistent issue with no official resolution. Since this was a critical challenge in a recent project of mine, I\u2019d like to share my solution. [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/","og_site_name":"dbi Blog","article_published_time":"2025-02-21T05:50:00+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Why Data Pump Fails to Import Scheduler-Programs","datePublished":"2025-02-21T05:50:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/"},"wordCount":429,"commentCount":1,"keywords":["Data pump","dbms_metadata","dbms_scheduler","import","program argument","scheduler","scheduler job","scheduler program"],"articleSection":["Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/","url":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/","name":"Why Data Pump Fails to Import Scheduler-Programs - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2025-02-21T05:50:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/why-data-pump-fails-to-import-scheduler-programs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Why Data Pump Fails to Import Scheduler-Programs"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/37197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=37197"}],"version-history":[{"count":4,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/37197\/revisions"}],"predecessor-version":[{"id":37291,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/37197\/revisions\/37291"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=37197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=37197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=37197"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=37197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}