{"id":1141,"date":"2023-05-01T20:32:36","date_gmt":"2023-05-02T00:32:36","guid":{"rendered":"https:\/\/gonzalo.aro.cl\/blog\/?p=1141"},"modified":"2023-05-04T20:53:14","modified_gmt":"2023-05-05T00:53:14","slug":"consultas-sobre-las-plataformas-en-oracle-con-su-little-o-big-endian","status":"publish","type":"post","link":"https:\/\/gonzalo.aro.cl\/blog\/2023\/05\/01\/consultas-sobre-las-plataformas-en-oracle-con-su-little-o-big-endian\/","title":{"rendered":"Consultas sobre las plataformas en Oracle con su Little o Big Endian"},"content":{"rendered":"<p>Esta es la consulta para listar las plataformas que Oracle tiene disponibles para ser instalada, pero adem\u00e1s esta consulta expone el formato Endian en que est\u00e1n. Esto ultimo es sumamente importante al momento de una migraci\u00f3n, ya que los script de Oracle lo utilizan para saber la plataforma origen.<\/p>\n<pre class=\"brush: sql\">SELECT platform_name, endian_format, platform_id\r\nFROM v$transportable_platform\r\nORDER BY platform_name;\r\n<\/code><\/pre>\n<p>La respuesta normal debiese ser<\/p>\n<pre class=\"brush: bash\">PLATFORM_NAME                                                                                         ENDIAN_FORMAT  PLATFORM_ID\r\n----------------------------------------------------------------------------------------------------- -------------- -----------\r\nAIX-Based Systems (64-bit)                                                                            Big                      6 \r\nApple Mac OS                                                                                          Big                     16 \r\nApple Mac OS (x86-64)                                                                                 Little                  21 \r\nHP IA Open VMS                                                                                        Little                  19 \r\nHP Open VMS                                                                                           Little                  15 \r\nHP Tru64 UNIX                                                                                         Little                   5 \r\nHP-UX IA (64-bit)                                                                                     Big                      4 \r\nHP-UX (64-bit)                                                                                        Big                      3 \r\nIBM Power Based Linux                                                                                 Big                     18 \r\nIBM zSeries Based Linux                                                                               Big                      9 \r\nLinux IA (32-bit)                                                                                     Little                  10 \r\nLinux IA (64-bit)                                                                                     Little                  11 \r\nLinux x86 64-bit                                                                                      Little                  13 \r\nMicrosoft Windows IA (32-bit)                                                                         Little                   7 \r\nMicrosoft Windows IA (64-bit)                                                                         Little                   8 \r\nMicrosoft Windows x86 64-bit                                                                          Little                  12 \r\nSolaris Operating System (x86)                                                                        Little                  17 \r\nSolaris Operating System (x86-64)                                                                     Little                  20 \r\nSolaris[tm] OE (32-bit)                                                                               Big                      1 \r\nSolaris[tm] OE (64-bit)                                                                               Big                      2 \r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Esta es la consulta para listar las plataformas que Oracle tiene disponibles para ser instalada, pero adem\u00e1s esta consulta expone el formato Endian en que est\u00e1n. Esto ultimo es sumamente importante al momento de una migraci\u00f3n, ya que los script de Oracle lo utilizan para saber la plataforma origen. SELECT platform_name, endian_format, platform_id FROM v$transportable_platform [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,4,9],"tags":[],"class_list":["post-1141","post","type-post","status-publish","format-standard","hentry","category-base-de-datos","category-desarrollo","category-oracle"],"_links":{"self":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/1141"}],"collection":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/comments?post=1141"}],"version-history":[{"count":6,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/1141\/revisions"}],"predecessor-version":[{"id":1151,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/1141\/revisions\/1151"}],"wp:attachment":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/media?parent=1141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/categories?post=1141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/tags?post=1141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}