{"id":249,"date":"2010-04-28T10:52:05","date_gmt":"2010-04-28T05:22:05","guid":{"rendered":"http:\/\/www.oratraining.com\/blog\/?p=249"},"modified":"2010-04-28T10:52:05","modified_gmt":"2010-04-28T05:22:05","slug":"operating-systems-endian-formats-for-migrating-databases-across-platforms","status":"publish","type":"post","link":"https:\/\/www.oratraining.com\/blog\/2010\/04\/operating-systems-endian-formats-for-migrating-databases-across-platforms\/","title":{"rendered":"Operating Systems Endian formats for migrating databases across platforms"},"content":{"rendered":"

Nowadays DBAs face requirements for migrating databases across different platforms like from Windows to Linux or Solaris or vice versa. While doing this we would require to use transportable tablespaces or cross-platform transportable tablespaces. In order to decide whether the migration would be simple or will involve file conversion, following command is used to identify platform endian format. If the endian formats are same then the process pretty straightforward.<\/p>\n

\n
SQL> select * from v$transportable_platform order by platform_id;<\/span><\/p>\n

<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
PLATFORM_ID<\/strong><\/span><\/td>\nPLATFORM_NAME<\/strong><\/span><\/td>\nENDIAN_FORMAT<\/strong><\/span><\/td>\n<\/tr>\n
1<\/span><\/td>\nSolaris[tm] OE (32-bit)<\/span><\/td>\nBig<\/span><\/td>\n<\/tr>\n
2<\/span><\/td>\nSolaris[tm] OE (64-bit)<\/span><\/td>\nBig<\/span><\/td>\n<\/tr>\n
3<\/span><\/td>\nHP-UX (64-bit)<\/span><\/td>\nBig<\/span><\/td>\n<\/tr>\n
4<\/span><\/td>\nHP-UX IA (64-bit)<\/span><\/td>\nBig<\/span><\/td>\n<\/tr>\n
5<\/span><\/td>\nHP Tru64 UNIX<\/span><\/td>\nLittle<\/span><\/td>\n<\/tr>\n
6<\/span><\/td>\nAIX-Based Systems (64-bit)<\/span><\/td>\nBig<\/span><\/td>\n<\/tr>\n
7<\/span><\/td>\nMicrosoft Windows IA (32-bit)<\/span><\/td>\nLittle<\/span><\/td>\n<\/tr>\n
8<\/span><\/td>\nMicrosoft Windows IA (64-bit)<\/span><\/td>\nLittle<\/span><\/td>\n<\/tr>\n
9<\/span><\/td>\nIBM zSeries Based Linux<\/span><\/td>\nBig<\/span><\/td>\n<\/tr>\n
10<\/span><\/td>\nLinux IA (32-bit)<\/span><\/td>\nLittle<\/span><\/td>\n<\/tr>\n
11<\/span><\/td>\nLinux IA (64-bit)<\/span><\/td>\nLittle<\/span><\/td>\n<\/tr>\n
12<\/span><\/td>\nMicrosoft Windows 64-bit for AMD<\/span><\/td>\nLittle<\/span><\/td>\n<\/tr>\n
13<\/span><\/td>\nLinux 64-bit for AMD<\/span><\/td>\nLittle<\/span><\/td>\n<\/tr>\n
14<\/span><\/td>\nHP Open VMS<\/span><\/td>\nLittle<\/span><\/td>\n<\/tr>\n
15<\/span><\/td>\nApple Mac OS<\/span><\/td>\nBig<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/span><\/span><\/div>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Nowadays DBAs face requirements for migrating databases across different platforms like from Windows to Linux or Solaris or vice versa. While doing this we would require to use transportable tablespaces or cross-platform transportable tablespaces. In order to decide whether the migration would be simple or will involve file conversion, following command is used to identify […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4,8,9,10],"tags":[56,57,60,196,138],"class_list":["post-249","post","type-post","status-publish","format-standard","hentry","category-oracle","category-database","category-oracle-database-cloning","category-oracle-dba","tag-cross-platform-transportable-tablespace","tag-database-migration","tag-endian-formats","tag-oracle","tag-transportable-tablespace"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/comments?post=249"}],"version-history":[{"count":0,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/posts\/249\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/media?parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/categories?post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oratraining.com\/blog\/wp-json\/wp\/v2\/tags?post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}