{"id":755,"date":"2013-12-05T11:30:39","date_gmt":"2013-12-05T10:30:39","guid":{"rendered":"http:\/\/clemente.pamplona.name\/dba\/?p=755"},"modified":"2013-12-31T11:17:52","modified_gmt":"2013-12-31T10:17:52","slug":"consultas-sobre-tablas-particionadas","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/consultas-sobre-tablas-particionadas\/","title":{"rendered":"Consultas sobre tablas particionadas"},"content":{"rendered":"<p><strong>Nos hemos mudado a bloger!<br \/>\nEl contenido actualizado de esta entrada lo tienes en:<\/strong><\/p>\n<ul>\n<a href=\"http:\/\/dba.pamplona.name\/2013\/12\/consultas-sobre-tablas-particionadas.html\" title=\"http:\/\/dba.pamplona.name\/2013\/12\/consultas-sobre-tablas-particionadas.html\">http:\/\/dba.pamplona.name\/2013\/12\/consultas-sobre-tablas-particionadas.html<\/a><\/p>\n<p>Hola de nuevo.<br \/>\nTras un largo par\u00f3n, vamos a volver con otra nueva entrada de <em>SQL para dummies <\/em><br \/>\nVamos a ver algunas consultas interesantes para cuando se trabaja con tablas particionadas.<\/p>\n<p><strong>Mover una particion de un tablespace a otro <\/strong><\/p>\n<pre>\r\nALTER TABLE  MITABLA  MOVE PARTITION   PART_GRANDE \r\n     TABLESPACE TS_NUEVO NOLOGGING;\r\n\r\n<\/pre>\n<p><strong>Tama\u00f1o de las particiones <\/strong><\/p>\n<pre>\r\n select  b.TABLE_OWNER,\r\n         b.TABLE_NAME,b.PARTITION_NAME,\r\n         sum(a.bytes)\/1024\/1024 Mb \r\n  from\r\n          dba_segments a,\r\n         dba_tab_subpartitions b\r\n  where \r\n       a.segment_name=b.table_name \r\n       and a.PARTITION_NAME=b.SUBPARTITION_NAME\r\n  group by b.TABLE_OWNER,b.TABLE_NAME,b.PARTITION_NAME\r\n  order by TABLE_NAME\r\n\r\n<\/pre>\n<p><strong>Tama\u00f1o de las particiones de una determinada tabla <\/strong><\/p>\n<pre>\r\nselect \r\n   owner,\r\n   segment_name,\r\n   segment_type,\r\n   partition_name,\r\n   bytes\/1024\/1024 Mb\r\nfrom\r\n    dba_segments \r\nwhere segment_name='TABLA'\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Nos hemos mudado a bloger! El contenido actualizado de esta entrada lo tienes en: http:\/\/dba.pamplona.name\/2013\/12\/consultas-sobre-tablas-particionadas.html Hola de nuevo. Tras un largo par\u00f3n, vamos a volver con otra nueva entrada de SQL para dummies Vamos a ver algunas consultas interesantes para &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/consultas-sobre-tablas-particionadas\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/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":[125],"tags":[248,126,256,127],"class_list":["post-755","post","type-post","status-publish","format-standard","hentry","category-partitioning-2","tag-dummie","tag-particionamiento","tag-plsql","tag-sql"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/755","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=755"}],"version-history":[{"count":8,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/755\/revisions"}],"predecessor-version":[{"id":840,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/755\/revisions\/840"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=755"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}