{"id":1487,"date":"2016-06-09T21:45:00","date_gmt":"2016-06-09T19:45:00","guid":{"rendered":"https:\/\/clemente.pamplona.name\/dba\/?p=1487"},"modified":"2016-07-28T12:53:03","modified_gmt":"2016-07-28T10:53:03","slug":"detectar-trabajos-suspendidos","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/detectar-trabajos-suspendidos\/","title":{"rendered":"Detectar trabajos suspendidos"},"content":{"rendered":"

Vamso a ver una entrada r\u00e1pida y sencilla.<\/p>\n

\u00bfComo sabemos cuando y por que se nos ah quedado parado un impdp?<\/h1>\n

La respuesta es muy sencilla, y es chequeando la table DBA_RESUMABLE<\/b><\/p>\n


\nSELECT NAME,STATUS, TIMEOUT, ERROR_NUMBER, ERROR_MSG FROM DBA_RESUMABLE;
\n<\/code><\/p>\n

Esto nos dar\u00e1 una salida del estilo :<\/p>\n

\r\nNAME                                STATUS            TIMEOUT, ERROR_NUMBER, ERROR_MSG\r\nSYSTEM.IMPORT_REGENERACION2\tNORMAL\t       7200\t0\r\nSYSTEM.IMPORT_REGENERACION2.1\tSUSPENDED\t7200\t1652\tORA-01652:      no se ha podido ampliar el segmento temporal con 1024 en el tablespace USERS\r\n<\/pre>\n
Donde podemos ver claramente que estamos parados por un ORA-01652<\/b> por culpa de espacio en un tabelspace <\/p>\n","protected":false},"excerpt":{"rendered":"
Vamso a ver una entrada r\u00e1pida y sencilla. \u00bfComo sabemos cuando y por que se nos ah quedado parado un impdp? La respuesta es muy sencilla, y es chequeando la table DBA_RESUMABLE SELECT NAME,STATUS, TIMEOUT, ERROR_NUMBER, ERROR_MSG FROM DBA_RESUMABLE; Esto … Sigue leyendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,60,6,9,66],"tags":[249,254,246,629,97,106,57,631],"class_list":["post-1487","post","type-post","status-publish","format-standard","hentry","category-11g","category-12c","category-backup","category-dummie","category-errores-ora","tag-11g","tag-12c","tag-backup","tag-dba_resumable","tag-expdp","tag-impdp","tag-ora","tag-suspendido"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1487","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=1487"}],"version-history":[{"count":1,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1487\/revisions"}],"predecessor-version":[{"id":1488,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1487\/revisions\/1488"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1487"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}