{"id":1487,"date":"2016-03-02T17:07:12","date_gmt":"2016-03-02T14:07:12","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1487"},"modified":"2016-03-02T17:07:12","modified_gmt":"2016-03-02T14:07:12","slug":"ora-31634-job-already-exists-when-export-operation","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/ora-31634-job-already-exists-when-export-operation\/","title":{"rendered":"ORA-31634 job already exists When Export Operation"},"content":{"rendered":"<p><strong>Error<\/strong><\/p>\n<blockquote><p>ORA-31634: job already exists<br \/>\nORA-31664: unable to construct unique job name when defaulted<\/p><\/blockquote>\n<p>This error normally occurs when you do not specify a unique JOB_NAME for the DataPump job  and for some reason that JOB_NAME already exists in the database, or else if you are running many jobs at the same time (more than 99 jobs) and DataPump cannot create a new job.<\/p>\n<p><strong>Solution<\/strong><br \/>\n<!--more--><br \/>\nTo fix this issue you have to cleanup the orphaned datapump jobs. You can obtain which has to drop tables with below query. After you can execute result set to drop tables.<\/p>\n<blockquote><p>SQL> SELECT &#8216;DROP TABLE &#8216; || o.OWNER || &#8216;.&#8217; || o.OBJECT_NAME || &#8216; PURGE;&#8217;<br \/>\nFROM dba_objects o, dba_datapump_jobs j<br \/>\nWHERE o.owner=j.owner_name<br \/>\nAND o.object_name=j.job_name<br \/>\nAND j.state=&#8217;NOT RUNNING&#8217;;<\/p>\n<p>And execute result set. <\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Error ORA-31634: job already exists ORA-31664: unable to construct unique job name when defaulted This error normally occurs when you do not specify a unique JOB_NAME for the DataPump job and for some reason that JOB_NAME already exists in the database, or else if you are running many jobs at the same time (more than&#8230;<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[32,54],"class_list":["post-1487","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-nZ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1487"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1487\/revisions"}],"predecessor-version":[{"id":1488,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1487\/revisions\/1488"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1487"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}