{"id":1057,"date":"2014-09-24T21:16:10","date_gmt":"2014-09-24T19:16:10","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=1057"},"modified":"2014-09-25T09:32:07","modified_gmt":"2014-09-25T07:32:07","slug":"para-un-job-de-impdp-de-manera-correcta","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/para-un-job-de-impdp-de-manera-correcta\/","title":{"rendered":"Para un job de impdp de manera correcta"},"content":{"rendered":"

Hoy vamos a ver otra de esas entradas \u00fatiles del d\u00eda a d\u00eda.<\/p>\n

En la entrada eliminar datapumps fallidos <\/a> vimos como borrar los trabajos de impdp\/expdp que estaban en entado fallido. Pero \u00bfque ocurre si queremos detener un trabajo en ejecuci\u00f3n ?<\/p>\n

Lo primero que haremos es volver a usar la consulta para ver el estado de los trabajos.<\/p>\n

\r\nSET lines 200\r\nSELECT owner_name, job_name, operation, job_mode,\r\nstate, attached_sessions\r\nFROM dba_datapump_jobs\r\nORDER BY 1,2;<\/pre>\n
Y vemos que tenemos un JOB en modo de ejecucion<\/p>\n
\r\nOWNER_NAME JOB_NAME    OPERATION JOB_MODE  STATE  ATTACHED\r\n\u2014\u2014\u2014- \u2014\u2014\u2014\u2014\u2014\u2014- \u2014\u2014\u2014 \u2014\u2014\u2014 \u2014\u2014\u2014\u2013 \u2014\u2014\u2013\r\nSCOTT      EXPORT_TABLA_1 EXPORT  TABLE   EXECUTING  0\r\nSYSTEM     EXPORT_DIARIA  EXPORT FULL     NOT RUNNING 0\r\n<\/pre>\n
Si lo que queremos es detener ese trabajo EXPORT_TABLA_1 de manera correcta, ejecutaremos:<\/p>\n
\r\nSET serveroutput on\r\nSET lines 100\r\nDECLARE\r\n   h1 NUMBER;\r\nBEGIN\r\n  -- Format: DBMS_DATAPUMP.ATTACH('[job_name]','[owner_name]');\r\n   h1 := DBMS_DATAPUMP.ATTACH('SEXPORT_TABLA_1','SCOTT');\r\n   DBMS_DATAPUMP.STOP_JOB (h1,1,0);\r\nEND;\r\n\/\r\n<\/pre>\n
Ejecutando la consulta que muestra los jobs de exports vemos que tenemos trabajos NOT RUNNING residuales, siempre podemos limpiar la tabla con el resultado de :<\/p>\n
\r\nSELECT 'DROP TABLE '|| owner_name||'.'|| job_name ||';'\r\nFROM dba_datapump_jobs\r\nwhere STATE='NOT RUNNING';\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Hoy vamos a ver otra de esas entradas \u00fatiles del d\u00eda a d\u00eda. En la entrada eliminar datapumps fallidos vimos como borrar los trabajos de impdp\/expdp que estaban en entado fallido. Pero \u00bfque ocurre si queremos detener un trabajo en … Sigue leyendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,60,6],"tags":[246,183,97,106],"class_list":["post-1057","post","type-post","status-publish","format-standard","hentry","category-11g","category-12c","category-backup","tag-backup","tag-datapump","tag-expdp","tag-impdp"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1057","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=1057"}],"version-history":[{"count":5,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1057\/revisions"}],"predecessor-version":[{"id":1063,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1057\/revisions\/1063"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1057"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1057"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}